MySQL Forums
Forum List  »  Optimizer & Parser

same query takes more time for different tables
Posted by: Radhakant Samal
Date: February 24, 2011 05:09AM

I have one table which has 3096 records.


While i am retrieving data joining this


table it takes more time ie 6657 ms to fetch 215 rows.


This time varies for each


execution between 5000 and 6000 but the same block of code when


used to retrive data from another table having some 616 rows, but it returns 347


records in 47ms . please give some clue to it.



Edited 1 time(s). Last edit at 02/24/2011 05:10AM by Radhakant Samal.

Options: ReplyQuote


Subject
Views
Written By
Posted
same query takes more time for different tables
2474
February 24, 2011 05:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.