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 Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]