in reply to Re: Basic Perl trumps DBI? Or my poor DB design?
in thread Basic Perl trumps DBI? Or my poor DB design?

SO, I'm embarking on a matrix of tests on that schema

All you really need to do is learn how to use EXPLAIN. It will tell you how the database processes the query so you can adjust things to make it use correct indexes.

  • Comment on Re^2: Basic Perl trumps DBI? Or my poor DB design?

In Section Seekers of Perl Wisdom