Posted by Dikkie Dik on 09/15/05 20:15

Maybe my article at http://www.w-p.dds.nl/article/wtrframe.htm
describes something useful. Especially the section on lazy collections
can be interesting.

Best regards.

nospammmer@gmail.com wrote:
> Hello group,
>
> I have a rather general but interesting inquiry that is related to PHP
> and I hope this is the appropriate place to post it.
>
> I'm looking for a way to improve dramatically the performance of my PHP
> application. The application is getting slow as it is taking more load.
> It is performing a very high number of queries to a database, and I
> believe that this is taking up most of the ressources.
>
> I'm trying to figure out how I could cache the content of the database
> and prevent that many queries to be performed.
>
> What I would like to do is cache all the content of the database in
> memory, so that I could access it directly through my PHP application
> without querying the database and saving precious ressources.
>
> The database is quite small, 15 - 20 mB and it's size is constant (it
> does not get bigger over time). 92% of the queries are SELECT, only 8
> percents are UPDATE, DELETE and INSERT.
>
> So, my question is, is it possible and recommandable to place 20mB of
> data in shared memory in order to prevent queries to the database? (all
> updates, deletes and inserts are performed both in the database as well
> as in memory)
>
> Or would I be better to place a copy of the database on a ramdrive?
>
> Other info:
> I have a server which runs both the PHP application and the MySQL
> database. It has 1GB of RAM. The database receives 250 queries / sec.
>
> Thank you in advance for your kind help
>

[Back to original message]