Harini, can you post the output you get from the EXPLAIN command?
That is, type "EXPLAIN " and then the query below, and MySQL will show
you an execution plan for the query that could help identify why it's
taking so long.
Dan
On 9/27/06, Harini Raghavan <[EMAIL PROTECTED]> wrote:
Hi All,
I
Hi All,
I am using MyISAM storage engine for 2 of the tables in my application
so as to use the full text search features. When I join any one of the
MyISAM table with other INNODB table, the query is very fast. But, if I
do inner join with both theMyISAM table, then the query takes 5 mins to
