× [JOOMLA 2.5 IS NO LONGER SUPPORTED]
Looking for a useful answer?

Read this first and make sure you checked all steps: www.csvimproved.com/frequently-asked-questions/635-troubleshooting-import-errors

Don't just say it doesn't work but describe in detail what is happening and add the following information:
* VirtueMart version
* CSVI version (Latest is not a version number)
* Sample of the file being imported
* Collected debug information

Without this information you won't get a useful answer. If no debug log is attached, you will get a request to post it.

Where to get the debug information?

A tutorial ( www.csvimproved.com/frequently-asked-questions/390-how-to-collect-debug-information ) has been written to help you collect your debug information.

Slow VirtueMart product imports/pricing updates

More
3 years 3 months ago #47654 by GuenterB
GuenterB replied the topic: Slow VirtueMart product imports/pricing updates
I have the same problems with the slow import of about 100thousand products. Unfortunatelly I saw this thread too late.
But in my actual virtuemart database I found two identical indexes in the product_price table. The first one is for the key virtuemart_product_id, the second for the key product_price. Both keys have an index on the virtuemart_product_id.

So its not necessairy to create a third index. My question is - who is responsable for this two identical indexes? the virtuemart installation or csvi?

Please Log in or Create an account to join the conversation.

More
3 years 3 months ago #47656 by rolandd
rolandd replied the topic: Slow VirtueMart product imports/pricing updates
Hello,

So its not necessairy to create a third index.

What brings you to this conclusion? A table can have a number of indexes, each with it's own use. The duplicate one you see is indeed useless, at least one of them. The product_sku index is still useful.

My question is - who is responsable for this two identical indexes? the virtuemart installation or csvi?

VirtueMart, CSVI doesn't create any indexes on the VirtueMart tables.

Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.

More
3 years 3 months ago #47658 by GuenterB
GuenterB replied the topic: Slow VirtueMart product imports/pricing updates
Sorry, but I was only talking about this:

mbrando wrote: Then I noticed that the prices was not there. VM has a price table too. So I looked for the _virtuemart_product_prices table and added an 'index' to the virtuemart_product_id field.

Please Log in or Create an account to join the conversation.

More
3 years 3 months ago #47661 by rolandd
rolandd replied the topic: Slow VirtueMart product imports/pricing updates
Indeed, for the prices table it is no longer necessary as VM seems to have 2 indexes on the same field :)

Kind regards,

RolandD

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.