After several years using Openbravo Pos in my family’s business, My father says that cash desk closing takes about 5 minutes and growing every day that was a bit annoying.
- backup database
- reconfigure my.conf enabling innodb_file_per_table,
- restart mysql
- drop database
- and pass a mysqlcheck with optimize option
didn’t show a big performance increase.
Finally the solution was adding indexes into tables.
ALTER TABLE TAXLINES ADD INDEX receipt (RECEIPT); ALTER TABLE TAXLINES ADD INDEX taxid (TAXID); ALTER TABLE TAXES ADD INDEX category (category); ALTER TABLE RECEIPTS ADD INDEX money (money);