09-17-2012, 02:58 PM
[eluser]tinawina[/eluser]
The result set for some of my queries numbers in the thousands and so pages were taking a huge amount of time to load. I turned on database caching and things are zipping along at a terrific pace. Phew!
Brief background: We collect and share publications posted to our site by our users. People can log into our site and add a publication anytime. We check the records they create and if they meet our criteria we make them available on the site. I understand that I can set things up so that when we approve something for display we run $this->db->cache_delete() to remove the old cache file. Is there a way to automatically cache the new page query as well?
I guess we could add a display of a link to the page in question right after updating our database that says something like "Click <here> to update the database cache".... but if I can automate this so as not to have to rely on human interaction (or non-interaction -- people do make mistakes) that would be great.
Thanks for your ideas!
The result set for some of my queries numbers in the thousands and so pages were taking a huge amount of time to load. I turned on database caching and things are zipping along at a terrific pace. Phew!
Brief background: We collect and share publications posted to our site by our users. People can log into our site and add a publication anytime. We check the records they create and if they meet our criteria we make them available on the site. I understand that I can set things up so that when we approve something for display we run $this->db->cache_delete() to remove the old cache file. Is there a way to automatically cache the new page query as well?
I guess we could add a display of a link to the page in question right after updating our database that says something like "Click <here> to update the database cache".... but if I can automate this so as not to have to rely on human interaction (or non-interaction -- people do make mistakes) that would be great.
Thanks for your ideas!