SQL_CALC_FOUND_ROWS slow?
I have a query that is joining 5 tables. The main table has about 850,000 records in it.
I run a query in phpmyadmin and it returns about 260,000 ordered matches (of course I limit to 20) and it does this in about .003 to .004
BUT
when I add SQL_CALC_FOUND_ROWS to that I can determine the number of rows the time suddenly slows to about 15-16 seconds.
I also tried the second quiry with count and it was just as slow - is there any way around this?
Thanks
Scott
Subject
Written By
Posted
SQL_CALC_FOUND_ROWS slow?
June 24, 2005 06:35AM
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.