Slow product display in VM 2 admin, front end OK [SOLVED]

[scarrigan]

We are upgrading from Joomla 1.5 / Virtuemart 1 to Joomla 2.5.8 / Virtuemart 2.0.18.

Product display on admin side takes 60 to 70 seconds. Other com_virtuemart views are OK. Front end product display is also OK.

Please help me diagnose what is going on here to require 60 seconds for page view. There are only about 1,400 products. Production version of site (old version) is running fine on the same server.

http://www.avantresources.com/testsite/administrator/index.php?option=com_virtuemart&view=product

Email me for temporary admin access.

Thanks!

[Maxim Pishnyak]

Ofc general advice in most cases is to update VM/Joomla to the latest versions.

I tried to turn off using jquery from Google source. This wouldn't help much BUT I've got interesting message:
alterTable CHANGE j25_virtuemart_products_en_gb.product_desc :
vmError: Tableupdater updating table j25_virtuemart_products_en_gb throws error Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `j25_virtuemart_products_en_gb` CHANGE COLUMN `product_desc` `product_desc` VARCHAR(18400) NOT NULL DEFAULT ''

It seems that smart VM told me that you made some direct operation(s) in the web shop database.
I can't do much without access to phpmyadmin.

Also if you could remove temporally some your VM addons (VMA etc) it could help identifying your problem.

In the end I saw that your MySQL type connection chosed as MySQLi, which is not typical at all.
Try at your own risk to chose this option as MySQL in your Joomla global settings.

[scarrigan]

Before changing anything, I ran mysql SHOW FULL PROCESSLIST and discovered there is a sleep process that runs for 60 seconds. As soon as it reaches 60, the page loads. What does that suggest?

[scarrigan]

Debugging revealed this to be a misplaced fucnction trying to connect to an external database. Issue closed. Thanks.

[fricikoma]

Ok but how can I solve the problem? I have the same issue.