Categories
View Replies (5)

Resolved Import Virtuemart products problems

  1. Terry_Karv
    Terry_Karv
  2. RO CSVI
  3. Sunday, 14 October 2018
  4.  Subscribe via email
Hi guys!

Something very strange happens after upgrading to 7.9.0

While I have set 250 lines per import and all worked ok so far for 5 lines per import I need 20sec !!

I have the message: "The last server response has not been received in a timely fashion. The server may still be busy or stopped the process. You can wait a little longer to see if the server will sent a response or cancel the process." so i tried to change the lines per import

250 lines nothing happens
200 lines the same
50 lines 30 sec + 42sec and then the server response!
5 lines 10-20sec!!!

Ιs server problem or something else to look at?

Regards
Terry_K
0
Responses (5)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Terry,

Can you post the debug log of your import? This should show which part of the import is taking so long. If you are importing external images, the problem may lie there as it could make the import process wait for retrieving the file from the external server.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Terry_Karv
Terry_Karv
Accepted Answer Pending Moderation
Hello Roland,

This file is from a canceled import because it took 112 minutes!!

Regards
Lefteris com_csvi.log.459.zip
Attachments (1)
com_csvi.log.459.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Terry/Lefteris,

The debug log shows where the time is going. Every time a query is done on the category table it takes 3-4 seconds. Check this part of the log


2018-10-14	20:39:09	2	[DEBUG]	Checking category

2018-10-14	20:39:15	2	[DEBUG]	COM_CSVI_DELETE_OLD_CATEGORIES_XREF

2018-10-14	20:39:15	2	[QUERY]	 DELETE  FROM `qwr63_virtuemart_product_categories` WHERE `virtuemart_product_id` = 26773

2018-10-14	20:39:15	2	[DEBUG]	Check if a category reference already exists

2018-10-14	20:39:15	2	[QUERY]	 SELECT COUNT(*) AS total FROM `qwr63_virtuemart_product_categories` WHERE `virtuemart_product_id`  = 26773 AND `virtuemart_category_id`  = 461

2018-10-14	20:39:15	2	[DEBUG]	Category reference does not exist yet

2018-10-14	20:39:18	2	[DEBUG]	COM_CSVI_ADD_NEW_CATEGORY_REFERENCES

2018-10-14	20:39:18	2	[QUERY]	 INSERT INTO `qwr63_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES  ('26773','461','')

2018-10-14	20:39:18	2	[ADD]	COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED

2018-10-14	20:39:18	2	[QUERY]	 INSERT INTO `qwr63_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES  ('26773','461','')

2018-10-14	20:39:18	2	[DEBUG]	Check if a category reference already exists

2018-10-14	20:39:18	2	[QUERY]	 SELECT COUNT(*) AS total FROM `qwr63_virtuemart_product_categories` WHERE `virtuemart_product_id`  = 26773 AND `virtuemart_category_id`  = 469

2018-10-14	20:39:18	2	[DEBUG]	Category reference does not exist yet

2018-10-14	20:39:22	2	[DEBUG]	COM_CSVI_ADD_NEW_CATEGORY_REFERENCES

2018-10-14	20:39:22	2	[QUERY]	 INSERT INTO `qwr63_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES  ('26773','469','0')

2018-10-14	20:39:22	2	[ADD]	COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED

2018-10-14	20:39:22	2	[QUERY]	 INSERT INTO `qwr63_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES  ('26773','469','0')


Do you have a very, very large category list? Looking further into the log, it is always the category table that is slowing things down. You may need to optimize this table and see if it improves performance.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Terry_Karv
Terry_Karv
Accepted Answer Pending Moderation
Thanks Roland,

I will check my database because i added new categories to my shop. Some of the old categories must be the problem. I will try to delete them.

Thanks again

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Let me know how it goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!