Best performance with InnoDB engine in the #_jshooping_products table

25.10.2012 11:00
Joomshopping forum user no avatar
Name: Eduardo
Posts: 53
Best performance with InnoDB engine in the #_jshooping_products table

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.


Website Url:
Copyrights MAXXmarketing GmbH. All Rights Reserved