Best performance with InnoDB engine in the #_jshooping_products table

25.10.2012 11:00
#1
slion2000
Joomshopping forum user no avatar
Name: Eduardo
17.10.2011
Сообщения: 53
Quote
Best performance with InnoDB engine in the #_jshooping_products table

Hello,
We are needing more performance in the access to the table jshopping_products. We check that the problem is in the engine of that table (It´s MyISAM).
We know that the MyISAM engine locks the table when you try to do a read of the full table. This fact produces a long lock and Joomla goes down for a few time.

We have tried to convert that table to InnoDB but we receive this error: "ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs"

It would be interesting that MaxxMarketing would try to use InnoDB in the most important tables of JoomShopping for the next versions.

Thanks.


Website Url: http://www.sexshopworld.xxx
 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.