Re: Re: High bandwidth application tips

on 11/7/03 12:08, rush at pipa@rush.avalon.hr wrote: > "Luis Lebron" <llebron@sigmatech.com> wrote in message > news:CE5C3E60DCF0D5118C7F00A0C9EBCE23041593@SIGMA2... >> I have been coding php for a few years now, but I haven't build a "high >> bandwidth" application. I am currently working on an application for a >> customer that may have a very large amount of users (10,000 or more >> according to the customer). Are there any good reference books, articles >> and general information on building such a site. I have been "googling" > for >> a while but have found anything on this particular topic. > > Well, here are some, somewhat ordered by importance: > > * use recent mysql 4.x The new versions have ability to cache results of > often used queries, and return the results very fast without even touching > the disk. Note that this is much better for web apps than usual query > cacheing that many databases offer. > * mark directories with static images as cacheabe. > * use page output compression on your pages. > * if you have some parts of the page(s) that are expensive to calculate > introduce some cacheing mechanic in your app. How do you get mysql to do it's own caching like you mentioned? Rick This is the final test of a gentleman--his respect for those who can be of no possible service to him. - William Lyon Phelps