I have a table where I just write.
Think of it as a "transactional" list, where I save all the details, and I also have a "general" stored in another table. This amount is redundant for performance, but can be recalculated, if necessary, from this transaction table.
Which is better in terms of performance, bearing in mind that several people will simultaneously use INSERTING (never UPDATE) for this table, which is never read?
Should I use InnoDB or MyISAM?
(I already have performance problems, I am not optimizing ahead of schedule)
source
share