On Aug 05, 2006, at 1:34 PM, D Jungk wrote:
Hi Norman,
First, I really appreciate the time people spend helping with
things like
this. This is my first project using a real database, so maybe my
assumptions
aren't right. But wouldn't searching 500,000 records with two
things to match
(bookID and text phrase) be a lot slower than searching in only one
table of
10,000 record with only one phrase to match?
Possibly.
If you make book ID a indexed field then it would not be that much
slower.
The main question is what do you want your users to be able to do ?
If being able to find any usage of a phrase in any book that has been
entered is important then doing it all in one large table has
significant advantages and the speed issues _may_ be addressable.
What you are suggesting certainly looks more direct and simple to
work with. I
guess my main question is the speed, whcih I can test by trying it.
Yes, and there may be other ways to deal with speed issues IF you
find any
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
