Without db cache, the query time is 1.2s, with db cache installed, it went up to 2.5s, so its about double!
My site loads faster with that cache...
[Plugin: DB Cache] Doubles the query time for me! (3 posts)
-
softtouch_ph
Posted 8 months ago # -
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.
-
Pinoy.ca
Posted 2 months ago #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.
Reply
You must log in to post.
