in reply to Re^2: Basic Perl array intersection faster than mysql query join.
in thread Basic Perl array intersection faster than mysql query join.

The acess path that the database pick might not be the most optimized one.

The EXPLAIN command can be useful when trying to figure out exactly what the database is doing, and how to optimise it.

  • Comment on Re^3: Basic Perl array intersection faster than mysql query join.

In Section Seekers of Perl Wisdom