04-16-2003, 07: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, 02:59 PM
have you tried indexing the fields that will be searched?
04-23-2003, 10:25 PM
Its just one big old comma daliminated file.
how would you index that and how could that effectivly help?????
04-23-2003, 11:07 PM
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"