Re: Optimizing a MySQL Query

[lhoward]

1. 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 ?"
   +);
   $sth->execute($category,$letter);
   

2. Make sure your DB has good indexes on category and sitename.

[Cine]

You add indexes in mysql by writing create index indexname ON main (category) in the mysql program... See CREATE INDEX

T I M T O W T D I