Re: Large database, slow search times

* Adrian Teasdale <adrian@europeantenders.com>: > 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 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". Two things come to mind: 1) INDEX! And, since you're on MySQL, do a fulltext index of the column you're searching on. 2) Read up on the MATCH () ON () syntax in the MySQL documentation. -- Matthew Weier O'Phinney | mailto:matthew@garden.org Webmaster and IT Specialist | http://www.garden.org National Gardening Association | http://www.kidsgardening.com 802-863-5251 x156 | http://nationalgardenmonth.org