same query takes more time for different tables

[Radhakant Samal]

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.