SEO

#1 (**permalink**) 02-28-2008, 09:26 AM

Hello

I have Two tables (ENGINE=MyISAM), each table (t1 and T2) have a
primary key bigint (ID),

I execute the request

Select count(*) from t1 inner join t2 on t1.id =t2.id;

it take s8 secondes

in eahc tables i have more the 2 million records and more. Can anyone
provide me a suggest to resolve this problem (Changing Mysql
parameters ...?)

Thanks in Advance

#2 (**permalink**) 02-28-2008, 09:27 AM

> I execute the request

> Select count(*) from t1 inner join t2 on t1.id =t2.id;
>
> it take s8 secondes
>
> in eahc tables i have more the 2 million records and more. Can anyone
> provide me a suggest to resolve this problem (Changing Mysql
> parameters ...?)

Your query has no SARGs (search arguments) so the query has to process
all rows in the outer table (one of this 2 mill. tables).

This query will never work fast on such big tables.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Time optimisation of "Inner Join"