Jump to content

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

Is It Safe To Create Index On Cscart_Products.product_Code? Rate Topic   - - - - -

 
  • Jacek
  • Senior Member
  • Members
  • Join Date: 13-Dec 12
  • 159 posts

Posted 14 November 2019 - 10:23 AM #1

Hi,

I have an integration with cscart which retrieves data from cscart_products via product_code field.

 

I'm wondering if it's safe to create index on this field like that:

CREATE INDEX product_code_index ON cscart_products(product_code);

I've got following questions:

1) Will it cause trouble during feature cs-cart upgrades?

2) Will it also speed things up while searching via product_code from the admin panel?

3) Is it safe?

 

Thanks for the answers!



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11442 posts

Posted 15 November 2019 - 04:59 AM #2

It should not cause a problem (unless you made it UNIQUE).  Rarely are searches done by product code that are not done on other indexed columns so the performance improvement is probably negligible unless you have an extremely large products table or product_options_inventory table..


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.