OXID Shop: Can I just change table type from InnoDB to MyISAM?
Posted on 2010-09-10
I run the OXID onlineshop on my server. To synchronize with the inventory control system, I use a plugin called "eShopConnector". It is a Windows Software, that synchronizes the inventory to the shop.
During the synchronisation, verry often I got a process with the state "freeing items" and during the time, the process was in the state (about 2-5 minutes), the update of the inventory get stalled. Now I changed the type of the "articles" table from InnoDB to MyISAM and everything works fine for me now.
My Question is now: Can I simply redeclare the type of the table or do I have to expect some negative consequences?