Как ускорить работу обмена vamshop с 1с?

[support 447]

Добавьте индексы в базу:

set sql_mode = '';
ALTER TABLE products_extra_fields ADD INDEX guid_idx (guid(255));
ALTER TABLE products_extra_fields_values ADD INDEX guid_idx (guid(255));
ALTER TABLE products_to_products_extra_fields ADD INDEX guid_idx (guid(255));
ALTER TABLE categories ADD INDEX guid_idx (guid(255));
ALTER TABLE manufacturers ADD INDEX guid_idx (guid(255));
ALTER TABLE orders ADD INDEX guid_idx (guid(255));
ALTER TABLE orders_products ADD INDEX guid_idx (guid(255));
ALTER TABLE orders_products_attributes ADD INDEX guid_idx (guid(255));
ALTER TABLE orders_products_download ADD INDEX guid_idx (guid(255));
ALTER TABLE products ADD INDEX guid_idx (guid(255));
ALTER TABLE products_attributes ADD INDEX guid_idx (guid(255));
ALTER TABLE products_attributes_download ADD INDEX guid_idx (guid(255));