We can't tell you how to improve your query, however, without seeing the query. We can't tell you if the table structure is the problem without seeing it. We can't comment on your indexes without knowing what they are. You have to help us to help you.
To learn how mysql sees your query, put EXPLAIN in front of it, as documented in the manual <http://dev.mysql.com/doc/mysql/en/explain.html>. Then, if you still need help, send us the output of EXPLAIN, as well as the output of "SHOW CREATE TABLE tablename" for each table used in the query.
Michael
On Apr 6, 2005, at 5:56 AM, arjun_iet wrote:
hi All,
I am trying to fech some data from some interrelated tables. I am using inner joins to relate tables. but mysql takes 7-8 sec to execute the query.
What could be the reason of such delays ? I would like to specify that one of the interrelated table contains around 3000 rows.
I tried to break the query in saperate spets but it couldn't help me .
If anyone has any suggestion reagarding above then please drop me a mail.
thanx Arjun
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]