• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Caching (only a specific entry)

#1
Hi Everyone,

In one of my applications I have thousands of users registered. I want to use CodeIgniter's database caching to speed things up.
I need a type of functionality that if some user updates his profile information, only the query pointing to his profile info delete from the cache not all the queries pointing to all users' profiles.

I read the user_guide and it gives an example of how to delete certain files from cache as,
Code:
$this->db->cache_delete('blog', 'comments');
, but the problem is that the example will delete all of the comments, not for example a comment related to some user.

In this type of scenario, (deleting only certain user's cache, who recently updated his profile, so that his/her cache is re-generated, or deleting only comments by a certain user, or comments by all users on certain post), the codeigniter's database cache isn't enough.

What will be the solution for this kind of functionality?

Thank you.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.