• Resolved Mantu2

    (@mantu2)


    Hi,

    Query monitor gives me constantly some erros about W3TC:

    Slow queries: W3TC\DbCache_WpdbNew->default_query
    Duplicate Queries: W3TC\DbCache_WpdbNew->default_query

    What can I do for fixing this? Admin panel works slightly slow and this might to do something with it.

    Second thing: I’m using WPML on multisite. W3TC suggests that I should upgrade to pro version. I tried to find the very good reasons to do this, but I found no good information why updating would make my site faster. How is the update related to WPML? What are my benefits.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Marko Vasiljevic

    (@vmarko)

    Hello @mantu2

    I am sorry about the issue you are experiencing and I am happy to assist you with this.
    As I can see you are on shared hosting.
    Database caching can make your site faster if the time needed to get data from the database is more than the time needed to get data from the cache.
    So, if you are on shared hosting, then RAM-based caching is likely to be unavailable for you. And disk-based caching is not that efficient. In other words, if you are on shared hosting, it’s recommended not to use database caching.
    Moreover, using disk-database caching (on shared hosting) can make your site slower. This is so because getting data from the database can be faster than getting cached data from the disk.
    You can try to use Object Cache instead. Object Cache allows getting data from the database more efficiently. Its purpose is similar to what Database Cache does. But compared to Database Cache, Object cache is more efficient as it allows to process fewer requests.
    As a rule of thumb, Object Cache is not worth using on shared hosting for the same reason as Database Cache, i.e. database is often not the performance bottleneck, but disk input-output operations.
    As for your inquiry regarding the upgrade, Yes W3 Total Cache offers better compatibility with WPML, however, I’ve tested your website on both GtMetrix and Google page speed and the results are great so basically there is not much more that you can do to improve your website performance.

    I hope this helps.
    Thank you!

    Thread Starter Mantu2

    (@mantu2)

    Hi,

    thanks for fast reply.

    So far I’ve been following is WPML’s notes about how to setup W3TC. They have work the best so far. At the moment I am not willing to use Object Cache. When doing this, the site won’t work as wanted. Seems that the settings are as good as possible at the moment. However, I’ll have a look what happens if database cache is disabled.

    Website speed for customers is fine. I’m mostly worried about the admin panel speed. I’ll ask WPML what can I do with the admin panel speed. It is their plugin what makes it slow.

    Viljo

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Slow queries’ is closed to new replies.