The loading speed is to ssslllooowww

Hi FPaulides,

The best ways to speed of loading would be to split into smaller chunks instead of one very large catalogue, to turn off searching of anything other than name for the text search area, and to set “Custom Slugs Conversion” to “No”.

Dear Rustaurius,

The suggestion you give me, I’ve done those already but do not change the loading speed in any kind of way.

Next to that, how can I make the user search through all the products if they are divided over different catalogues?

Are you saying that your plugin is not capable of running faster? Or is it WordPress that is holding back the loading speed?

I hope you can give me more inside on this, thanks in advance!

Hi FPaulides,

It’s more of a limits of the transmission and access speeds problem.

I don’t know the particulars of your setup, but let’s say you had 3 layouts with 2400 products. If you’ve got 60 products per page, the HTML alone is going to be ~1MB, so that’s maybe 2 seconds of load time.

Next, if you’re filtering 2400 products, with say 2 categories selected and text in the text field, you’re looking at 7200 (3 x 2400) database requests. If each one last 0.005th of a second, that’s another 3.6 seconds of load time.

All that is on top of the standard connection times for loading a site, which would depend on your hosting. You could speed it up by hosting your site on an SDD or increasing the site bandwidth (or visitor connection speed), and we’re always looking to reduce the database called, string searches, etc. If you’ve got an improved function, we’d be happy to add it!

Thanks for the inside Rustaurius! If I understand your story correctly my site should run smooth. But it’s not, Chrome says the ttfb for the page is 28.44?s

Just to be sure this is my exact setup:
In total I have 2164 products with 3 extra costume fields.
Divided over 120 categories and 15 subcategories.

I currently have made 2 catalogues.
one with all the products
and one with 1 big category and 3 sub-categories, total of 691 products.

The smaller catalogue is the one I am test now (total loading speed of 31.2 sec). The other one is not work, it does not load at all.

So I will try different option like switch from https to http and also try a different hosting provider. Please let me know if you have other suggestion for me for now.

Hi FPaulides,

Does your hosting provide information on how fast the database requests are being processed? We test with a catalogue with ~500 products, a few categories, custom fields, etc. and 60 products per page. The load time before any HTML appears is ~4-5 seconds, with a few more seconds to load the images, so 31.2 seconds seems very long for the smaller catalogue.

I’m having a huge problem with this as well… it takes almost 20 seconds to load a catalog of 550 products.

Hi Jay,

Unfortunately, there are a quite a few factors that could be affecting the speed of your catalog. As mentioned above, we’ve tested large catalogs extensively and have not experienced load times anywhere near 20 seconds. Does your hosting provide information on how fast the database requests are being processed?

My host does not provide that information.

I have tested the page on Website speed test: https://tools.pingdom.com/fpt/#!/7OMc5/https://www.the-muse.dk/books/

It looks like the page is loading the full size main image as the thumbnail – I have a good feeling that this is the problem. Can this be changed to load the thumbnail instead?

Hi Jay,

We do have a “Thumbnail Support” setting in our options, but there is a bug with it right now and it isn’t working properly. We’re working on a fix for it for a future update.

Now I have so many items in my catalog that the page doesn’t even render… any idea when this will be fixed? I really don’t know what to do in the meantime. Only catalogs under 500 items will render and that is after a good 30 seconds.

I fixed my issue by deleting the databases related to the plugin. Reinstall the plugin and upload my products again. That worked for me…

Hi Jay,

Unfortunately, we don’t have a timeline at the moment. That being said, this is definitely going to happen. We’re still figuring out the best way to implement it.

One thing to note, though, is that, currently, if you have/create square images (exact same width and height), then the “Thumbnail Support” option will work.

Also, could you tell me how big the images you’re currently using are, on average (e.g. 500KB or 2MB)?

It sounds very interesting if the performance issue could be solved by deleting the database tables. the Performance in my case is also slow. I have 66 products but I saw that the wp99_upcp_fields_meta table has more then 6000 items.

Hi,

There is a chance that removing the extra (no-longer-needed) data from the upcp_fields_meta table could help to speed up your site. That being said, you need to be cautious when making changes directly in the database and definitely make sure you have a backup before trying to change anything.