WordPress.org

1. giulioplay
   Member
   Posted 1 year ago #

   Hi,

   I want just to know if a wordpress installation with this performance is normal or the memory used/queries is too high

   <!-- Generated in 1.257 seconds. Made 122 queries to database and 62 cached queries. Memory used - 29.44MB -->

   There are 16 plugin installed. Wp-Super-cache enabled (mod-rewrite) and DB cache reloaded enabled.

   Thanks.

2. Phil
   Member
   Posted 1 year ago #

   Depends what you have on the site, but doesn't look miles off.

3. giulioplay
   Member
   Posted 1 year ago #

   the site is http://www.ricettedellanonna.net

   db: 24 mb

   and that's all.

   My hosting provider told me that the cpu usage is considered excessive even for a VPS Plan. I can't believe that.

   Why onlyi 62 of 122 queries is cached? How can I increase the number of cached queries?

4. Ron Rennick
   MultiSite Guru
   Posted 1 year ago #

   If you want to improve your performance look at reducing the 122 queries. A default install uses less than 20. Any site running 122 queries is going to be slow and use excessive resources.

5. giulioplay
   Member
   Posted 1 year ago #

   I'm tring to do that. It's very strange how the number of queries in my local installation are very low, respect to the production server.

   In a single page, for example, I have 247 queries, while in local only 47.

   Can anybody tell me why?

   Now I'm no idea how can I reduce this number.

6. Ron Rennick
   MultiSite Guru
   Posted 1 year ago #

   With that big of a difference you have to have something different between your dev install and your live one. Try making the dev one a complete copy of the live one & turn various things off to see how it affects the number of queries,

7. giulioplay
   Member
   Posted 1 year ago #

   Ok, I reduce the number of queries and now I have:

   single page: 50 (was 247) 28 cached
   homepage: 90 (was 140) 48 cached
   archive, search, category : 41

   Memory used: 25 mb
   Loading time: 0,7 seconds

   I think this stats are enough for a VPS plan.

   What can I check even more?

8. Ron Rennick
   MultiSite Guru
   Posted 1 year ago #

   The DB caching plugin will never attempt to cache all of the queries. It's saving the ones WP caches to a persistent cache.

9. giulioplay
   Member
   Posted 1 year ago #

   What do you think of this stats?

   Do you think the combinatio of HyperCache-Db Cache Reloaded-Google Libraries is enough or I have to install also wp-minify for example?

10. giulioplay
    Member
    Posted 1 year ago #

    I receive a mysql log from my hosting provider in which I see there are many of this type of queries:

    SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (2)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (175)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (6)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (8)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (5)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (200)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (199)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (194)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (84)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (234)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (7)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (20)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (195)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (216)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (237)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (191)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (202)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (184)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (198)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (10)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (197)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (209)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (203)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (204)
    		     17 Query       SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (143)

    it's normal?

Topic Closed

This topic has been closed to new replies.