Jump to content

 

ymul

Member Since 09 Aug 2013
Offline Last Active Jul 05 2015 06:43 AM
-----

Posts I've Made

In Topic: Sql Optimisation

18 August 2014 - 07:59 PM

what is the size of this table cscart_product_features_values ? i've had a similar problem. the reason was in multiple time doubled products features. so when any filter was applied it walked through all these features.

@Alecomp : maybe you're righut :
Table cscart_product_features_values contains 1216 rows. We are using about 40 features, in 3 languages -> should we find about 120 rows in the table ? 1140 rows have an empty "Value" column.
Any idea to test and/or make corrections in that table ? Thanks a lot !

In Topic: Sql Optimisation

18 August 2014 - 07:51 PM

what is the size of this table cscart_product_features_values ? i've had a similar problem. the reason was in multiple time doubled products features. so when any filter was applied it walked through all these features.


@Alecomp, maybe you're right :
Table cscart_product_features_values contains 1216 rows.
We are using less than 40 features, in 3 languages. Should we have about 120 rows in that table ?
We had a lot of problems with the features in an earlier version...maybe there is still a problem in that table. A lot of rows have nothing in "Value" column. Any idea to test and make correction in that table ?
Thanks !

In Topic: Sql Optimisation

18 August 2014 - 07:42 PM

Product Filters = Database Engine.
Older versions of mySQL didn't support speed improvements made by later releases.
You are correct, product filters - but also look at your database/php version on your new host.

Mysql version on new host is 5.5.27

In Topic: Sql Optimisation

18 August 2014 - 07:48 AM

Have you tried another hosting?

I've changed to a VPS server. Global performances are now better.
But in my sense it has nothing to do with the host. These queries are on > 1'000'000 rows and returning 3 rows. This should not be normal on such a simple configuration. I'm almost sure that it has something to do with the product filters.

In Topic: Sql Optimisation

18 August 2014 - 06:48 AM

After more complains from my provider, I had to choose between installing another solution for my shop (!) or move to a VPS. My site is now on a VPS and the cas is now closed for my provider. But the problem is not resolved...

As suggested above, I opened a ticket, here is the conclusion of it :

Thank you for your message. I am afraid that we can not attempt to optimize these queries within our technical support service, so we can offer you the customization services of our affiliate company Simtech Development Ltd (it is our ex-Custom Development department now acting as a separate legal entity). Their website is www.simtechdev.com. For your convenience we can forward your request to Simtech Development Ltd for estimation, please let me know if you are interested in it.Thank you.


I'm suprised that nobody at CSC can find out where these queries are coming from... I'm also suprised to see that a helpdesk ticket is not the way to obtain a real technical support (what's the use of my support credits ?) and that I have to use the service of an affiliate company.

I'll will now do the upgrade from 4.1.5 to 4.2.1, maybe it will help. But if I encounter as many problems as with previous upgrades, I'll really think about alternatives...