Got a large database (350,000+ records) of books. I built a nice search 
interface for it with inputs for:

1. MAIN TABLE
    a. title
    b. author
    c. publisher

....and from additional tables with ids referencing the main table
2. book type (juvenile fiction, adult fiction, blah,
    blah...maybe 30 choices here in a dropdown)
3. subject matter (biography, auto-biography - about
    30 entries in a dropdown)

Worked great and gave the exact results I was hoping for.

Client says "Too complicated. Amazon does it with *ONE* input field. Do 
it like that."

Obviously Amazon has an army of coders at their disposal to write custom 
search functions for them. I don't see any good way of doing this with 
standard queries myself.

For example, with my multi-input form, finding non-fiction info on folks 
that made pottery was pretty easy by just putting "Potter" in the title 
field and and checking "non-fiction". Not a single "Harry Potter" book 
in the results!

If there's only one input field though ... see the problem? Especially 
when you consider that in addition to what I've listed above there's 
maybe another 10 reference tables.

Seems you'd have to break each word they entered into the field out 
separately: "non-fiction", "Potter", then check those against every all 
10-15 tables involved. With the number of records here doesn't seem a 
very efficient way of doing things and seems to have the potential to 
chew the server to a halt, seeing that you'd have to check all 10-15 
tables for "Potter", even though only the title field in the main table 
is relevant for that, and it would also run "non-fiction" against all 
tables too.

How would you handle this? Is there a search technology I need to be 
looking at (which is probably too expensive for this small indie 
bookstore to afford) - or would you try to force them back to the 
multi-input form?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286294
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to