Jump to content

Archived

This topic is now archived and is closed to further replies.

enkreativbyra

DMS theme creates hundreds of database queries

Recommended Posts

enkreativbyra

Hi!

 

I have a VPS with 4gb ram and 4 cpus, it is pretty well optimized and serves other wordpress sites really fast. In fact, it serves sub-sites on my multisite superfast if it's using another theme than DMS.

 

So, what is up with this? For one of my subsites it did about 270 queries and took about 2 sec to complete, then the site starts to load, so the wait time is really long.

 

It scores really well, between 90-96 on yslow (grade A or B depending if it uses CDN) and pingdom.

 

 

Running latest wordpress with the latest dms. Not much plugin and only very good ones, like gravityforms.

Share this post


Link to post
Share on other sites
enkreativbyra

So how come it makes such a lot of queries? What can be done to improve the speed? The files are not loading slow, but the hole experience feels pretty slow.

 

I don't really want to use wp supercache or w3tc since I don't like the way those handles multisite installations.

Share this post


Link to post
Share on other sites
Danny

Hi,

 

I am not a database expert, but the 270 queries doesn't sound right. I will speak to one of our developers and see what they suggest.


Please search our forums, before posting!

Share this post


Link to post
Share on other sites
Simon

What were the 270 queries?

Share this post


Link to post
Share on other sites

  • Similar Content

    • gstrahle
      By gstrahle+
      Hi,
      Is there anything that can possible be done to improve the loading performance of PageLines Platform and Elements?
      https://goldenstategreens.com/wp-content/plugins/pl-platform/engine/ui/js/common.js?ver=946207(180.5KiB) https://maps.gstatic.com/maps-api-v3/embed/js/36/11/init_embed.js(146.6KiB) https://maps.googleapis.com/maps/api/js?client=google-maps-embed&paint_origin=&libraries=geometry,search&v=3.exp&language=en_US®ion=us(99.3KiB) https://goldenstategreens.com/wp-includes/js/jquery/jquery.js?ver=1.12.4(87.0KiB) https://goldenstategreens.com/wp-content/plugins/pl-section-slider/flickity.js?ver=946207(48.2KiB) https://goldenstategreens.com/wp-content/plugins/pl-section-impulse/owl.js?ver=946207(35.3KiB) https://goldenstategreens.com/wp-content/plugins/pl-platform/engine/ui/js/site.js?ver=946207(18.8KiB) https://goldenstategreens.com/(17.5KiB of inline JavaScript) https://secure.gravatar.com/js/gprofiles.js?ver=2019Apraa(15.9KiB) https://goldenstategreens.com/wp-includes/js/jquery/ui/effect.min.js?ver=1.11.4(11.6KiB) https://goldenstategreens.com/wp-includes/js/jquery/ui/tabs.min.js?ver=1.11.4(9.6KiB) https://s0.wp.com/wp-content/js/devicepx-jetpack.js?ver=201917(9.4KiB) https://goldenstategreens.com/wp-content/plugins/pl-section-lax/parallax.min.js?ver=946207(7.8KiB) https://goldenstategreens.com/wp-includes/js/jquery/jquery-migrate.min.js?ver=1.4.1(7.7KiB) https://goldenstategreens.com/wp-includes/js/jquery/ui/accordion.min.js?ver=1.11.4(6.4KiB) https://goldenstategreens.com/wp-includes/js/jquery/ui/widget.min.js?ver=1.11.4(6.1KiB) https://goldenstategreens.com/wp-content/plugins/pl-section-meganav/superfish.js?ver=946207(4.4KiB) https://goldenstategreens.com/wp-includes/js/jquery/ui/core.min.js?ver=1.11.4(3.3KiB) https://goldenstategreens.com/wp-content/plugins/pl-section-meganav/meganav.js?ver=946207(2.2KiB) https://goldenstategreens.com/wp-content/plugins/pl-section-meganav/sticky.js?ver=946207(2.2KiB) https://goldenstategreens.com/wp-content/plugins/pl-section-impulse/impulse.js?ver=946207(1.7KiB) https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3355.356766011451!2d-117.21045368481853!3d32.75626678097826!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x80deaaeffa185a7f:0x6613dd77eb86c21!2sGolden+State+Greens!5e0!3m2!1sen!2sus!4v1552542527201(1.5KiB of inline JavaScript) https://goldenstategreens.com/wp-includes/js/wp-embed.min.js?ver=5.1.1(1.2KiB) https://goldenstategreens.com/wp-content/plugins/google-analyticator/external-tracking.min.js?ver=6.5.4(975B) https://goldenstategreens.com/wp-content/plugins/jetpack/modules/wpgroho.js?ver=5.1.1(716B) https://goldenstategreens.com/wp-content/plugins/jetpack/_inc/build/widgets/milestone/milestone.min.js?ver=20160520(488B) https://goldenstategreens.com/wp-content/plugins/pl-section-flicky-posts/js/script.js?ver=946207(469B) https://goldenstategreens.com/wp-content/plugins/jetpack/_inc/build/photon/photon.min.js?ver=20130122(395B) https://goldenstategreens.com/wp-content/plugins/pl-section-lax/lax.js?ver=946207(352B) https://goldenstategreens.com/wp-content/plugins/pl-section-slider/slider.js?ver=946207(319B)  
      We are working on site loading performance and would like to get a passing grade, and our load time down to 3 seconds.  We will be making updates to the content size to bring it down as well. Please let me know if there is anything that can be done to address the loading issues found here within PageLines Plugins.
      https://gtmetrix.com/reports/goldenstategreens.com/5rnupbNu
       
      Thanks
    • JawDesigns
      By JawDesigns
      Hi everyone,
      Flywheel have reported errors on my clients site 'www.racewaredirect.co.uk' and it's not loading. Can someone please provide some information on how to fix this? The site has never experienced these issues before.
      Thanks,
      James Wilson
    • jinfinite8
      By jinfinite8+
      Hi, I'm a long time PageLines and DMS user. Trying out Platform 5 now.
      Does Platform 5 store data like DMS 2 as serialized data, or does it store data in a regular WordPress mysql table?
      Thanks very much.
      ~ julian
    • eveliut
      By eveliut
      Hi there,
      My server provider has contacted me saying that my Pagelines website is spamming from their server. There's plenty of trojans and other viruses. I got a list from them and it's huge. Any ideas on how to fix this and how did this happen in the first place? They have already deleted some of the content from my site. Thanks.

    • Buishi
      By Buishi
      For some reason, in one of my DMS installs, there are over 1,000 CSS files, what's going on? They're in wp-content/uploads/pagelines, and are numbered like so:
      compiled-css-core-1410368544.css
      compiled-css-core-1410373848.css
      compiled-css-core-1411613503.css
      Etc... all the way down to file 1,080:
      compiled-css-sections-1437665197.css
      The most recent one is today, of which there are two, the oldest is from Sept 30 of last year, which is close to when I launched the site.
      Ideas welcome, thanks!
      -Julian
×