Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Sql Optimisation Rate Topic   - - - - -

 
  • ymul
  • Member
  • Trial users
  • Join Date: 09-Aug 13
  • 41 posts

Posted 18 August 2014 - 07:51 PM #21

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 !

 
  • ymul
  • Member
  • Trial users
  • Join Date: 09-Aug 13
  • 41 posts

Posted 18 August 2014 - 07:59 PM #22

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 !

 
  • Cart-Power
  • Senior Member
  • Authorized Reseller
  • Join Date: 12-May 14
  • 1650 posts

Posted 20 August 2014 - 12:24 PM #23

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


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.
Cart-Power.com / Cart-Power.ru (sales@cart-power.com) offers you:
CS-Cart add-ons :: CS-Cart themes :: CS-Cart development :: CS-Cart license
Работаем с англоязычными и русскоязычными клиентами (work with English-speaking and Russian-speaking customers)