mysql load, help with ideas related to local cache

[Wade Preston Shearer]

On 24 Feb 2009, at 15:51, Matt Nelson wrote:

> I have a web page that runs under PHP.  I query a mysql database  
> every 5-10 seconds, with each meta refresh.  This was fine and  
> worked decent, until other people started using it.  Now the  
> connections have grown to a number that they need to be handled  
> better.  I was thinking of creating a daemon that runs every 5  
> seconds and then populates a flat file that apache/php would read  
> with every refresh thus limiting the load to one connection every 5  
> seconds.
>
> Does anybody have any better ideas?

How often is the data in the database changing. The answer to that  
makes a difference as to what the best solution will be.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2431 bytes
Desc: not available
Url : http://plug.org/pipermail/plug/attachments/20090224/3c07a067/attachment.bin