In the case of using Mysql/Mariadb, as a datasource with MYISAM or InnoDB Engine, I have a customer order management app, where we will have FACT-type tables, where about 300 records are generated daily (DETAIL-ORDER), which is 9000 month, 108,000 per year with about 10 interactive users, inserting, modifying and consulting and deleting records. Questions 1) Which will be the most convenient DB engine, MYISAM or INNODB?, 2) Does MYISAM or INNODB affect the size of the data exchange file with Appsheet's internal DB, since I always see Appsheet generates the Mysql/MariaDB DB with "MYISAM" engine, but I don't know whether to change it to INNODB, since we know that InnoDB in some cases doubles or even triples the physical size of the DB on the Server, due to the generation of internal foreign key control structures, and others internal elements and required by InnoDB. @Steve @Marc_Dillon
LinkedIn
Twitter
