WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: DB Cache] Doubles the query time for me! (3 posts)

  1. softtouch_ph
    Member
    Posted 5 years ago #

    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...

  2. Samuel Wood (Otto)
    Tech Ninja
    Posted 5 years 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.

  3. Pinoy.ca
    Member
    Posted 4 years 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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags