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