+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: CI db->cache_delete() only specific queries? (/showthread.php?tid=15182)
CI db->cache_delete() only specific queries? - El Forum - 01-28-2009
[eluser]Unknown[/eluser]
Here's the scenario:
I have a db with many organizations in one table, and a table full of assets with a field indexing the organization key. I am pulling queries of select organizations and looping through all of their assets, using URL query string parameters for indicators as to what organizations to pull from.
Since this is a rather lengthy query it creates a performance drag on the server so I was thinking of using CI's db caching to cache the queries. Then, on asset update I want to delete the cache file of only the query that pertains to the particular organization and not wipe out the entire 'organization+asset' directory in which is resides. If I wipe out all of the cache files in 'organization+asset' upon single asset update the entire query must be rebuilt.
Is there flexibility in CI's db->cache_delete() to only delete cached instances inside the directory and not wipe out the entire 'organization+asset' dir?
Any help would be MUCH appreciated.
Thanks!