I would not allow the user to wildcard at the start of the names, and
require at least one letter of each name. Any good database engine should
do fine with those restrictions.
-----Original Message-----
From: Chad McCue [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 8:29 AM
To: CF-Talk
Subject: Querying a large database
Hey Everyone,
I have a quick question about querying a database with over 600 thousand
entries. The user has the ability to search by a name they type in. Now when
they click search I need to query two fields from this table to find the
name. Both fields in SQL are indexed. I need some ideas that will not kill
our server while someone is performing a search. Remember that the user will
be able to type in any part of a name, does not need to be the whole name.
Wildcard characters are used like this "%#name#%".
Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
