View Full Version : Wildcard freeze

04-16-2003, 08:48 PM
wildcard * before a search string generates a Table scan in the database, locking ALL records for ALL other uses causing everything to hang until the search is complete.

How can you make a web database search more effective?

04-19-2003, 03:59 PM
have you tried indexing the fields that will be searched?

04-23-2003, 11:25 PM
Its just one big old comma daliminated file.
how would you index that and how could that effectivly help?????

04-24-2003, 12:07 AM

Full text indexes are not updated more then once a day or so, even then
its not 100% so you can search for a product one day, find it, next day
it wont show... Its good for finding "almost everything"