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!) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
