Resolved Check table indexes and add them

Hello,
There is no option in CSVI maintenance menu to add indexes. You have to either add the index as explained in Speed up product import document or run a query in PHPMyAdmin to create index on product_sku field. The query will be like below, do not forget to replace #_ with your table prefix.

CREATE INDEX product_sku

ON #__virtuemart_products (product_sku);

Thanks, I know that, I also created a small system plugin which checks it and adds if it needs but I think it could be an option of the component too, because it's quite harmless but useful feature

Hello Toni,
Glad to know that you solved your issue.

Having an indexes field to a table is user dependent and so it is not included in CSVI. CSVI cannot take responsibility of managing users database as having too many indexes will slow down the insert/update/delete operations and increases size of the database though it makes reading a record faster. Also these indexes should be added only if needed. Unwanted indexes will cause harm to the system.

I agree, that's why I suggested a maintenance feature I have several customers who can use Joomla, Virtuemart and even CSVI, can build a CSVI template, do export-import, etc but they always ask me to do something because their import is very slow (~1000-5000 products in the CSV). So I have to add the index manually or install my custom plugin which checks it but maybe other users don't have this knowledge so a mainentance process with a warning could be useful for them. Or even a "remove index" option too.
There are also mainenance processes in CSVI which modify the database content and can do unexpected results if you use it wrong, like "empty database", "clean media files", "unpublish products by category", "remove product prices" etc.
And actually you suggest to do this to speed up the import:
https://csvimproved.com/support/import/203-virtuemart/1159-speed-up-product-import

Hello,
The current operations in CSVI maintenance menu of "empty database", "clean media files", "unpublish products by category", "remove product prices" are done by querying the tables and they wont harm or slow the database operations. By adding indexes there is more possibility for database operation to get affected. As of now we don't have any plans of adding indexes to maintenance menu. We will keep you posted if we add it in future.

Hello Toni,

I see your point about options to damage the database, I guess that is pretty much possible with everything in CSVI :whistle: If we are going to add the option to add it, in this case there should be an option to remove it as well.

The only thing I am thinking here is where do we draw the line. Is optimizing a website a feature of CSVI, because that is a little the area we are getting into. The better solution here would be if VirtueMart provided the index as it is their database schema. So really have mixed feelings towards this.