PHP cache

[fuge125]

Hello,

I want to cache a DB resultset using PHP. I want a webserver global cache I mean I want to init the cache only once a day and not once per request.
What solution should I use?

 

[HerpDerpSlerp]

Two tables and run a cron once a day updating the table?

 

[jazzc]

Memcached & Redis are made for this thing

 

[fuge125]

Can I use Memcached on a reseller hosting account or do I need VPS maybe a dedicated server?

 

[Gogol]

You can also implement query caching schemes using frameworks. It is much easier to handle as you don't have install any extensions or implement external classes. I use YII for example ( www.yiiframework.com)

 

[fuge125]

I nvere used Yii until now. I will chek it.

 

[tratata]

You also can use XCache var cache. I like XCache more than Memcached

 

[hip_hop_x]

Another cache method written in php is o1db, no other extension/software required, it caches on disk.

 

[fuge125]

Thanks for the tips! I will check them.

 

[agj32mrgibbits]

If you can't use memcached on shared hosting just dump the results into a file and update them when the file modified date is older than 24 hours.

 

[Gogol]

Not a bad method, but what if you have million rows of data? In that case, reading from file will be slower than reading from db!

If you can't use memcached on shared hosting just dump the results into a file and update them when the file modified date is older than 24 hours.

 

[mypmmail]

Not a bad method, but what if you have million rows of data? In that case, reading from file will be slower than reading from db!

Not really, the database store the data in a file system as well, just that the data format stored is more efficient.
And, typically, the database connection has to go through the network layer which is another resource to consume and database has control and transaction file to maintain.
The advantage of database is exactly for this purpose that it provide transaction control and rollback.

The problem with implementing your own is you need to do the maintenance yourself which is a hassle.
Thus, we should always use readily available implementation.

If your data is huge, cache usually has a limit, which mean it store only a portion of the million records that is being accessed frequently. (another reason why a readily available solution is used)

 

[Gogol]

Yeah Transaction is a factor. With that, How would you keep index of the data? What if you need to update them? I personally use filesystem only if I have a pretty small site to build, or do not have a database system available ( quite unlikely these days lol). I sometimes use MongoDb exactly for what you said.

Not really, the database store the data in a file system as well, just that the data format stored is more efficient.
And, typically, the database connection has to go through the network layer which is another resource to consume and database has control and transaction file to maintain.
The advantage of database is exactly for this purpose that it provide transaction control and rollback.

The problem with implementing your own is you need to do the maintenance yourself which is a hassle.
Thus, we should always use readily available implementation.

If your data is huge, cache usually has a limit, which mean it store only a portion of the million records that is being accessed frequently. (another reason why a readily available solution is used)

 

[codePerformance]

Hello,

I want to cache a DB resultset using PHP. I want a webserver global cache I mean I want to init the cache only once a day and not once per request.
What solution should I use?

In my opinion APC (Alternative PHP Cache) would be the best and easiest solution for your Use-Case.
If you got root access on your server simply type in:
pecl install APC

For a compact doc google for:
APC documentation PHP


Key Value stores like Redis or Memcached are better but much mroe complex to install, learn and mantain. Use a small solution first and then do an upgrade (if required).

 

[sephoral]

I use Redis for a key/value storage and even some more complex storage things. It is really powerful. Thing is you need some experience to install in on your server. But it's not that hard and you'll find lots of tutos out there

Regards