Is there any reason you are not paging it and fetching only 20, or 50 or
100 records at a time? That would significantly speed things up for you...
Regards,
--Kevin
--
Sign up for our Newsletter for updates.
http://cakephp.org/newsletter/signup
We will soon be closing this Google Group. But
hello everyone, this is my situation.
MSSQL server with query on a single table; timer says 4.47s, SQL Log says
1375 rows in 110ms.
Time spent in "controller action" is 3600ms and I further tried to inspect
the controller code, printing elapsed microseconds: it seems like the
assignment of