|
|
Posted by Daz on 10/28/06 21:01
pangea33 wrote:
> How many results do you get back? If your recordset is huge, the render
> time in your browser could be the problem rather than just the query.
>
> What does php do to the records as it's outputting them? Any sort of
> calculations?
The number of results varies. It can be 10, 20,30,50 or 100, and the
output is reformatted. However, I am using Dragonfly CMS, which tells
me how long the pages took to generate, and how long all of the queries
put together took to execute. I have also measured the time it takes to
execute the query myself using microtime(), and it's just taking far
too long. As I mentioned before, it never used to take as long, and
queries involving using other tables are still super-quick.
Navigation:
[Reply to this message]
|