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

A very good point, I agree with you.

He said compound key, so must be with two columns. However when you look at his query, he used only one column, so most likely the database was doing a full table scan instead of index scan.

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

In Section Seekers of Perl Wisdom