Posted by Manuel Lemos on 03/29/06 08:15

Hello,

on 03/27/2006 09:30 AM strawberry said the following:
> I have a question about improving page rendering speed.
>
> For instance, according to mysql the following query takes a mere 0.28
> secs:
>
> SELECT * FROM table1
> ORDER BY field1;
>
> 924 rows in set...
>
> however rendering the page displaying all that data can take over a
> minute which, without modifications to the php.ini file, can
> occasionally cause those timeout errors
>
> I know it's difficult to say too much without providing the script and
> hardware info but I was just wondering if anyone had any general tips
> about improving the speed at which the page displays.

The best tip to optimize what you want to do is to use content caching,
ie. in the first access generate the page and store it in a cache file,
for instance, and serve the page from the cache in the following accesses.

Here is a more detailed FAQ on database performance tricks and tips:

http://www.meta-language.net/metabase-faq.html#performance

--

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

[Back to original message]