...

View Full Version : Wildcard freeze



haskins
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?

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

haskins
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?????

haskins
04-24-2003, 12:07 AM
apparantly

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"



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum