You are here:  » WP plugin very slow to retrieve data


WP plugin very slow to retrieve data

Submitted by sociallyfamous on Thu, 2015-03-05 07:57 in

Hi

First of all HELLO. I am new here. I just got the package 2 days ago.
I will be probably have to ask a few questions here in the coming days as I do face a few issues.
Generally everything is going well.

Question:

I am using a lot of feeds: about 150 and the /pt installation is super fast.

However, the WP plugin is very slow to retrieve the data when searching or clicking on individual entries. It takes 5-10s to connect.

Any ideas on how to trouble shoot that. The PT installation itself is lightning fast though.

Submitted by support on Thu, 2015-03-05 08:07

Hello sociallyfamous and welcome to the forum!

Wordpress can have a lot going on depending on other plugins and theme features so what I would normally suggest, is first of all is WordPress acceptable in terms of page load speed for all other pages? For example, if you just go to the container permalink page ( /shopping by default), does that page load quickly, but then if you enter a search and can take 5-10s wheres from /pt/ results are pretty much instant?

If it's an option for you, one thing to try would be to drop back to the default WordPress twentyfourteen or twentyfifteen theme which should be installed (depending on WordPress version), and that would let us know if is some kind of theme factor that is causing the slow load times.

Also worth checking is to temporarily disable other plugins is possible, and if that speeds things up, re-enable your other plugins one by one which should enable you to identify if another plugin appears to be causing the slow load times.

If the site is online I'd be happy to take a look (I'll remove the URL before publishing) or if you're still not sure of course, let me know and I'll check it out further for you.

Cheers,
David.
--
PriceTapestry.com

Submitted by sociallyfamous on Thu, 2015-03-05 08:21

Hi David,

You are fast!

Well, the WP theme code is not super clean to say the least but its quite fast, the VPS server is decent with 3GB ram. Cashing is partly disabled now.

All pages load fast except for /shopping and individual product pages such as /produkt/5268-Hotel-Shop.html/

Sometimes they are a bit faster but not to compare with /pt.

Here are the sample links

{links saved}

I would appreciate any kind of guidance.

Thank you!

Submitted by sociallyfamous on Thu, 2015-03-05 08:41

To add to the above.

I have tried a few things by deactivating plugins... I seem to have reasonable success deactivating the Yoast Seo plugin. Trying further.

Submitted by sociallyfamous on Thu, 2015-03-05 08:53

OK.

I am stunned. I have been using the WP Yoast SEO plugin for all my sites for years.

Deactivating it makes the PT plugin a lot more faster, not as fast as the PT installation itself but still a lot faster. Like this it works for me!

Besides, the whole site feels faster too. Hm. It was the last plugin I removed. Who would have thought.

Thank you, and I am preparing the next question, where I hopefully won't seem like a total beginner :)

Submitted by support on Thu, 2015-03-05 09:08

No problem!

I'll see if I can re-create that on my test server - the SEO plugins are very popular and lots of users I know have them installed so I'll check it out, but otherwise glad you're up and running!

Cheers,
David.
--
PriceTapestry.com

Submitted by sociallyfamous on Thu, 2015-03-05 09:55

If you have any results on that I would be curious. I am continuing to test, and I am not sure if the Yoast SEO plugin has actually just generally affected the performance. There is still some lag retrieving the results, as mentioned in the initial problem. Sometimes it is fast, sometimes its lagging behind.

I still do not have any css applied to it and there is an encoding problem in WP that is not visible in /tp so maybe there is some relation too.

Submitted by support on Thu, 2015-03-05 10:05

Hi,

The encoding problem I'm aware of - this can happen due to difference in character encoding and collation between the WordPress and Price Tapestry tables. It's straight forward to fix by ensuring that the Price Tapestry database library uses the same connection encoding as WordPress - I'll email a patch to you in just a moment to apply this...

Cheers,
David.
--
PriceTapestry.com

Submitted by sociallyfamous on Thu, 2015-03-05 11:26

Is it possiblle that using the shortcode on the /shopping page is slowing down the output?

Submitted by support on Thu, 2015-03-05 11:34

It shouldn't do, but you could try as an experiment editing the Shopping page and temporarily removing the [pto] shortcode.

Do you have any Featured Products configured?

Cheers,
David.
--
PriceTapestry.com

Submitted by sociallyfamous on Thu, 2015-03-05 11:55

I do have one configured.

Submitted by support on Thu, 2015-03-05 12:15

Hi,

Using the plugin will never be as fast as standalone Price Tapestry because of the WordPress overhead (the raw time taken to generate the WordPress page itself). It might be worth seeing if you can identify a particular feature of your SEO plugin that is causing the effect as most SEO plugins have many options and it's more likely to be something specific than the plugin in general...

Cheers,
David.
--
PriceTapestry.com

Submitted by sociallyfamous on Thu, 2015-03-05 12:36

David

Thank you for holding my hand through this. It has found an end.

PERMALINK FINDER PLUGIN

This was the 2. part to the puzzle... messing around with the .html file loading up 11s per page.

So good. Now I can move on to the next step.

Got the patch thanks.

Submitted by sociallyfamous on Thu, 2015-03-05 12:38

I should have noticed earlier but I have some sort of cashing installed on the server, which makes troubleshooting always a bit tricky if you do not take the time to go slow.

I am flying now.

Submitted by support on Thu, 2015-03-05 12:39

Great!

Cheers,
David.
--
PriceTapestry.com

Submitted by sociallyfamous on Thu, 2015-03-05 16:42

The patch did the magic. Encoding issue solved.