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

Written By
same query takes more time for different tables
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.