RE: [PHP] Re: Large database, slow search times
Thanks for this. Will look into those :) Appreciate the help Ade 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Large database, slow search times
* Adrian Teasdale [EMAIL PROTECTED]: 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:[EMAIL PROTECTED] Webmaster and IT Specialist | http://www.garden.org National Gardening Association| http://www.kidsgardening.com 802-863-5251 x156 | http://nationalgardenmonth.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Large database, slow search times
Adrian Teasdale [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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 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. Thanks in advance for your advice Ade Have you put an index on the column? Regards, Torsten Roehr -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Large database, slow search times
Yup that is the solution, INDEX and match on Octavio -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php