Sql Optimisation

[quote name='Alecomp' timestamp='1408383062' post='189875']

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.

[/quote]



@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 !

[quote name='Alecomp' timestamp='1408383062' post='189875']

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.

[/quote]

@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 !

[quote name='ymul' timestamp='1408391997' post='189888']

@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 !

[/quote]



It is necessary additional investigation of problem on your server. If you wish, we could try resolve this issue for you as additional service. Please, contact us with access data if you are interested.