go ahead... be a heretic | |
PerlMonks |
Re: How to improve MYSQL search performance of perl?by radiantmatrix (Parson) |
on Aug 18, 2005 at 15:24 UTC ( [id://484817]=note: print w/replies, xml ) | Need Help?? |
This is not a Perl question, but a DB-optimization question (unless you want to write Perl code to intelligently combine queries and extract the data back out -- but that would probably *still* be slow). Make sure you have normalized your DB for the type of queries you wish to perform, and index the columns you are searching through. For example, if you have a table with columns: ID Name Age Details SSN Record_fileand you commonly search for records by Name and SSN, create indexes on those columns. Intelligent use of indexes, along with proper normalization, nets in huge speed gains in many circumstances.
<-radiant.matrix->
Larry Wall is Yoda: there is no try{} (ok, except in Perl6; way to ruin a joke, Larry! ;P) The Code that can be seen is not the true Code "In any sufficiently large group of people, most are idiots" - Kaa's Law
In Section
Seekers of Perl Wisdom
|
|