Posted by J2be on 03/29/06 13:44

"strawberry" <zac.carey@gmail.com> wrote in message
news:1143462615.500455.201670@t31g2000cwb.googlegroups.com...
>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...

Specify the columns and avoid the use of *.
Use LIMIT and use the paging for the results.
Cache the results when the data is updated
(except if you update the records in the db each minute)
and send the cached results to the client.

Regards.


--
Leonardo Armando Iarrusso - J2Be
www: http://www.J2be.com - e-mail: info[at]J2Be.com

[Back to original message]