With that many records I would say that you probably want to use a full-text search engine such as Lucene or Verity (built-in to CF). This will give you full text search and allow you to do some of the "did you mean" stuff.
I also think that giving someone 100 records and saying "your search returned more then 100 records, please redefine your search to get better results" would not be too out of line. I mean red is my favorite color but I don't expect Google to display my blog when I search for "red"... see what I mean? -J.J. On 6/25/07, Les Mizzell <[EMAIL PROTECTED]> wrote: > > I watching a huge CSV file of book titles import into a mySQL database > right now. It's about half way through and up to 350,000 records at this > point. I supposed to be building a search interface for this thing. > Hmmm... > > I just don't see a standard form with "Search for title, author, > publisher" getting it here, though that's the simple front end the > client has asked for. > > What if somebody can't remember the exact title of what they're looking > for, but they know that the word "red" is in the title, so that's all > they search for. They could get 25,000 returns from that. > > In theory, what's a better method to return manageable results from a > table with this many records? > > (...import is up over 425,000 records now.....ACK!) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282175 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
