RE: Yet Another Optimization Question

[Michael Widenius]

Hi!

>>>>> "Nigel" == Nigel Parker <nigel.parker@stripped> writes:

Nigel> It seems strange that url.id and pageview.id are different types for starters. 
> Don't know if that would have an impact.

This is the main reason why it's slow;  The current MySQL can't yet
optimize queries where columns are stored differently.

Jon, if you change url.id to mediumint, your query will be MUCH faster!

Regards,
Monty