Making pages load faster

[mikawhat]

Hello. I'd like to know if there are any techniques or tips, that have to do with php and mysql, to use in order to make my pages load faster.

[NogDog]

Write efficient SQL. Optimize your database -- a complex subject, but the first thing to do is make proper use of column indexes. Write efficient PHP. Output efficient HTML and use external CSS stylesheets for common presentation data. Optimize graphics for file size.

[MarkR]

Require fewer distinct resources, particularly Javascript and CSS, e.g. combine multiple .js or CSS files into one.

If the problem is the sheer amount of data (HTML), then use gzip compression on the output.

You can also tell the browser it may cache the page, by sending appropriate headers (Last-modified, expired etc, and disabling any no-cache headers). But only do this if it's appropriate.

Mark

[Ivan_]

See :
http://www.phpbuilder.com/columns/argerich20010125.php3

http://phpnuke.org/modules.php?name=PHP-Nuke_HOWTO&page=jpcache.html

http://phpnuke.org/modules.php?name=PHP-Nuke_HOWTO&page=cache-lite.html

[MarkR]

If you want to do server-side caching, you could also use Apache 2.2's caching features - you'll still need PHP to set the appropriate last-modified, expires, vary headers etc though.

Mark

[mikawhat]

OK. i'll try caching. Thank u all for your advices.