I had not seen this plugin before, so I took a look at it. Basically, it’s sorta similar to the old built-in object caching, for queries in specific. Clever, but I think it’s a tad misguided. Querying a database is probably going to be faster than looking for the same query in a filesystem manner. DB’s are optimized and efficent, filesystems have all sorts of caveats to cope with.
I’d not be surprised if this offers no improvements. If it does offer improvements, then likely your mySQL server needs some work.
If it does offer improvements, then likely your mySQL server needs some work.
Retrieving a past query result from the file system may be faster than a JOIN.
The plugin is better for shared hosting where one can’t tweak the MySQL config (query cache).
Plus, with this plugin’s “$tag” system, one can quickly hack it such that certain queries are cached longer, shorter or not at all.