mysql load, help with ideas related to local cache
Wade Preston Shearer
wadeshearer.lists at me.com
Tue Feb 24 17:16:49 MST 2009
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
> 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...
Size: 2431 bytes
Desc: not available
Url : http://plug.org/pipermail/plug/attachments/20090224/3c07a067/attachment.bin
More information about the PLUG