in reply to Optimizing a MySQL Query
- use DBI placeholders... (very rough code below)
my $sth=$dbh->prepare_cached("select sitename, url, country, language,
+ listing, description from main where category=? and sitename like ?"
- Make sure your DB has good indexes on category and sitename.