Massive Queries issue… Over 2500!

[Pothe]

Sorry, I just checked again and even without Cardinal, using twenty 14:

Total query time: 0.28720s for 752 queries.
Total num_query time: 2.595 for 753 num_queries.

It has to be the number of variations. We have 320 variations for each product.

[laranz – SUPPORT]

Hi,

Yes it is, did the WPML guys provide you solution.

Let us know,

Thanks,
laranz.

[Pothe]

Still no solution or from WPML. I am chasing them every day on it. So as soon as I know I will update.

Thanks

[Rui Guerreiro – SUPPORT]

Hi,

Those 320 variations can be problematic on the long run. It feels that editing a product it’s already slow. Those variations will consume a lot of memory plus the WPML in the middle.

There is no other way to categorize the product in a different to way to reduce the variations?
Maybe removing the Country? Not sure if you have different stock per Country.

You can restrict the delivery only to specified countries and select them.

-Rui

[Pothe]

We are investigating it now.

But the fact is that we have pricing as follows:
Size: S, M, L = 3 prices
Price per country = 100 prices

I have been trying to find a different way to do this. For example. Table rate shipping can handle many more options based on size, weight, for details such as post codes per country. Maybe there is a way to use shipping country and a table rate.

[Kyle – SUPPORT]

No problem, let us know how you get on.

– Kyle

[Pothe]

Hi…
I’ve been doing lots of testing.
I have just seen that the custom css we used has a big impact on page load. Most of the css is used to style things or move them around or hide them,

I’ll post the results in a private message and also the css we have been using.

[Swift Ideas – Ed]

Have you tried the css in the child theme css file?

Post the CSS here – http://pastie.org

-Ed

[Pothe]

🙂 I’ve just been testing this and it makes a huge difference.

I’ve moved some of the css to the child theme css, and removed the rest for now.

Do you see anything problematic?
http://pastie.org/9551472

For some of these changes I think it makes more sense to edit the template files rather than hiding it.

[Pothe]

Update…

I am getting very little response from you. Can you please get someone to take over. We are on a tight deadline and have bought your plugin in good faith.

I have set up on a dedicated server with wpengine. This is high grade hosting costing $700 a month. I have tested every step of the way.

You can see the result so far below…

Ive installed WPML, configured media translations and woocommerce multilingual. But no translations at all yet.
Before translating anything look at the difference of this one product page:

1. no WPML – 29 queries Clean install, widgets and page builder being used. (your theme is doing well!)
2. with WPML – jumped to 700 plus. Then cleaned cache, back down to 52 queries.
3. set up WPML, media and woocommerce integration etc. – 338 queries. The product I am testing hasn’t been translated yet. It has 300 variations. Imagine what will happen…

I have the query logs saved. I can send them is you are interested.

Any suggestions?

[Pothe]

This reply has been marked as private.

[Pothe]

I just unchecked this:

Make themes work multilingual…

This feature turns themes into multilingual, without having to edit their PHP files.

Adjust IDs for multilingual functionality

Note: auto-adjust IDs will increase the number of database queries for your site.

Better speed but same number of queries.

[Pothe]

This reply has been marked as private.

[Swift Ideas – Ed]

Only thing I can think of is that function would relate to navigating through the site in a certain language. Try it out to see if you get any issues?

– Ed