|
|
|
| Perl-Sensitive Sunglasses | |
| PerlMonks |
Re^3: Fetch Mysql huge databaseby aaron_baugher (Curate) |
| on Sep 29, 2011 at 20:37 UTC ( [id://928664]=note: print w/replies, xml ) | Need Help?? |
|
Yes. On a large table, indexes are essential for any field (or group of fields) which you're going to use to filter or order your results. Create an index on the UserName field here, and it'll drastically speed things up.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||