Re: [PHP] Large database, slow search times

2004-09-02 Thread Curt Zirzow
* 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 "12

[PHP] Large database, slow search times

2004-09-02 Thread Adrian Teasdale
Hi there I have been given the task of integrating a search into a database we have which contains 40 million records and I would really do with some advice! Thanks to everyone the other day who helped us parse this same database into mysql. Basically the database consists of only 1 field that s