Re: Basic Perl array intersection faster than mysql query join.

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

I wasn't clear from reading this if you indexed both colums individualy or not. You should have an index on each colum. This should result in a giant decrease in look up times.

___________
Eric Hodges

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

Replies are listed 'Best First'.
Re^2: Basic Perl array intersection faster than mysql query join. by pg (Canon) on Oct 12, 2004 at 20:46 UTC
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.	[reply]

In Section Seekers of Perl Wisdom