""Octavian Rasnita"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I am using a perl program (mod_perl handler) that searches a MySQL > database > which has a few hundread thousands records, using a fulltext index, but it > works pretty slow. When very many records are found, it takes very many > seconds or even tens of seconds to finish searching the database. > > Do you know if there is a faster method available for a perl program? >
Your post is off topic, as you'd have the same problem no matter what language your db client was using, but: To my knowledge, there are very few searching methods that are both faster and easier to set up than MySQL's MyISAM tables using fulltext searches. First, make sure you are using the proper syntax in your query to take advantage of the fulltext index. You can find that info at http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html. A query that utilizes the fulltext index looks different than "... WHERE fulltextcolum LIKE '%substring%'" so if you are using that then your query is not yet optimized. Next, your op says "When very many records are found..." What is the purpose of your client program loading large recordsets? You should probably be paging the data somehow. It definitely works great with 5 million+ records on just okay hardware. Todd W. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
