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"
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.