Re: Large database, slow search times

* Thus wrote Adrian Teasdale: > Hi there > > Basically the database consists of only 1 field that stores a set of > character strings. I need to be able to do a wildcard search that will > find any matches, so if I'm looking for any matches containing "ABC" > then it should pull up the record "123ABCDEFG". Now, I know that under > normal circumstances this wouldn't be too bad, but under this database > I'm getting search times of 3.5 minutes just to run one search. > Considering that there might be 500 users interested in doing searches > on this info, 500 x 3.5 minutes per search is too much. Just wondering > what the experts would suggest for managing a database this size and > getting the search times down to something manageable. mysql4.0.x or greater supports fulltext indexing, which would improve your searching. see: http://mysql.com/ Curt -- The above comments may offend you. flame at will.