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