while inserting data into component through impex throing erre

Question

$contentCatalog=apparel-ukContentCatalog $contentCV=catalogVersion(CatalogVersion.catalog(Catalog.id[default=$contentCatalog]),CatalogVersion.version[default=Online])[default=$contentCatalog:Online]

INSERT_UPDATE TopSellingProductComponent;$contentCV[unique=true];uid[unique=true];name;numberofproducts ;;topSellingProductComponent;top Selling Product Component;10

error is:[type TopSellingProductComponent is abstract - no permitted type for mode import_strict]}, definition please how to fix it

Answer 1

There is no simple way to optimize such a query.

You can build and maintain a Summary Table, then do the query from that table. This approach may achieve a 10-fold speedup.

More discussion: http://mysql.rjweb.org/doc.php/summarytables

Answer 2

You can create a covering index that includes all fields referenced in the query. Note for a large table it may take a considerable amount of time to build such an index.

Once the index is created you can check the explain plan to confirm that the query is using the index.

Presuming the index is being used, the performance should be dramatically improved for select query.

It is possible that the index slows down high volume insert/update statements, so give this some consideration..