[Skip to main content](#vessel-content) # Why is MyISAM used and not InnoDB? ## - **[esotechie](/forum/user/7143-esotechie "View esotechie's Profile")** - [![esotechie's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7143.jpg)](/forum/user/7143-esotechie "View esotechie's Profile") Topic Author - [ Offline](/forum/user/7143-esotechie) Less More - Posts: 180 - Thank you received: 13 - - - - [](http://www.halare.co.uk/) - 14 years 5 months ago [\#50945](#50945) by [esotechie](/forum/user/7143-esotechie "View esotechie's Profile") *[Why is MyISAM used and not InnoDB?](/forum/2-general-talk-about-hikashop/50945-why-is-myisam-used-and-not-innodb#50945 "Joomla uses InnoDB as the engine for it's tables, but I have noticed that Hikashop uses MyISAM. This strictly hampers addition of Foreign keys for data integrity on deletions, and from my...")* was created by *[esotechie](/forum/user/7143-esotechie "View esotechie's Profile")* Joomla uses InnoDB as the engine for it's tables, but I have noticed that Hikashop uses MyISAM. This strictly hampers addition of Foreign keys for data integrity on deletions, and from my understanding MyISAM is not as robust as InnoDB. So I would be interested to know what the reasoning behind using MyISAM is, and if changing the tables to use InnoDB would cause any issues. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUwOTQ1LXdoeS1pcy1teWlzYW0tdXNlZC1hbmQtbm90LWlubm9kYj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 5 months ago [\#50965](#50965) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Why is MyISAM used and not InnoDB?](/forum/2-general-talk-about-hikashop/50945-why-is-myisam-used-and-not-innodb#50965 "Joomla uses InnoDB as the engine for it's tables, but I have noticed that Hikashop uses MyISAM. This strictly hampers addition of Foreign keys for data integrity on deletions, and from my...")* When we started our work on HikaShop, Joomla 2.5 didn't exist. Joomla 1.5 was using MyISAM, so we did the same. Why not use innoDB now ? Because it would probably require to change some of the code/queries to cope with the modification, no one expressed any problem with that choice so far, and we prefer to focus for now on fixing bugs and adding more features to HikaShop. HikaShop's architecture will evolve in the future. InnoDB might be part of that evolution, but I don't think that this is an urging topic. The following user(s) said Thank You: [esotechie](/forum/user/7143-esotechie "View esotechie's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUwOTQ1LXdoeS1pcy1teWlzYW0tdXNlZC1hbmQtbm90LWlubm9kYj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[esotechie](/forum/user/7143-esotechie "View esotechie's Profile")** - [![esotechie's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7143.jpg)](/forum/user/7143-esotechie "View esotechie's Profile") Topic Author - [ Offline](/forum/user/7143-esotechie) Less More - Posts: 180 - Thank you received: 13 - - - - [](http://www.halare.co.uk/) - 14 years 5 months ago [\#50971](#50971) by [esotechie](/forum/user/7143-esotechie "View esotechie's Profile") Replied by *[esotechie](/forum/user/7143-esotechie "View esotechie's Profile")* on topic *[Re: Why is MyISAM used and not InnoDB?](/forum/2-general-talk-about-hikashop/50945-why-is-myisam-used-and-not-innodb#50971 "Joomla uses InnoDB as the engine for it's tables, but I have noticed that Hikashop uses MyISAM. This strictly hampers addition of Foreign keys for data integrity on deletions, and from my...")* Thank you for your reply Nicoals and for explaining the choice. It would give better referential integrity and in cases of database problems allow better troubleshooting. But as you say it is not vital to the functionality of the product and I can see that it will not be a pressing issue. In that case I may experiment in my own time if I think there is a need for any of the tables to be modified. Again thanks for taking the time to reply. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUwOTQ1LXdoeS1pcy1teWlzYW0tdXNlZC1hbmQtbm90LWlubm9kYj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 14 years 5 months ago [\#50974](#50974) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Why is MyISAM used and not InnoDB?](/forum/2-general-talk-about-hikashop/50945-why-is-myisam-used-and-not-innodb#50974 "Joomla uses InnoDB as the engine for it's tables, but I have noticed that Hikashop uses MyISAM. This strictly hampers addition of Foreign keys for data integrity on deletions, and from my...")* Great ! Let us know your findings if you get the time. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzUwOTQ1LXdoeS1pcy1teWlzYW0tdXNlZC1hbmQtbm90LWlubm9kYj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.052 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)