Number of queries and memory used

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

Viewing 9 replies - 1 through 9 (of 9 total)
  • Phil

    (@owendevelopment)

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

    Thread Starter giulioplay

    (@giulioplay)

    the site is https://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?

    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.

    Thread Starter giulioplay

    (@giulioplay)

    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.

    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,

    Thread Starter giulioplay

    (@giulioplay)

    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?

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

    Thread Starter giulioplay

    (@giulioplay)

    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?

    Thread Starter giulioplay

    (@giulioplay)

    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?

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Number of queries and memory used’ is closed to new replies.