how to build a in-memory server side cache in php?

php caching server-side in-memory
y62wang picture y62wang · Oct 13, 2011 · Viewed 12.6k times · Source

I am trying to reduce the amount of database access by providing a in memory cache. I understand that I can get a cache by using session and cookies, however this only works on a per client basis. if the same query is made once in every session, then the cache will be useless. But I only want to access the database once and have it cached.

Is there a way to make create a cache in memory that can be accessed by the server side script? I don't want to store the cache data in a file ..

Answer

GolezTrol picture GolezTrol · Oct 13, 2011

You can use MemCache, if installed.

Another option is creating a table in MySQL with storage type MEMORY. You will still use the database, but it will be quite a lot faster. But MemCache will really cut the load on the database, because you can cache the data outside the database, even on a different server.

Related questions

How to clear APC cache entries?

I need to clear all APC cache entries when I deploy a new version of the site. APC.php has a button for clearing all opcode caches, but I don't see buttons for clearing all User Entries, or all System …

Read More
Laravel 5 Clear Views Cache

I notice that Laravel cache views are stored in ~/storage/framework/views. Over time, they get to eat up my space. How do I delete them? Is there any command that could? I tried php artisan cache:clear, but it …

Read More
What is causing "Unable to allocate memory for pool" in PHP?

I've occasionally run up against a server's memory allocation limit, particularly with a bloated application like Wordpress, but never encountered "Unable to allocate memory for pool" and having trouble tracking down any information. Does anyone know what this means? I've …

Read More