is i7-1370p faster than m2 pro 10 cpu?

yeah you are right I think I will try to use view, and union

this will make me a better developer!

I think I will use this approach

but I think I need to use union to make a single table that is combination of accounting journal tables and view of transaction tables

some people use mongodb or redis for caching a query result

I'm really interested in this, pardon my english understanding.

did netsuite copying value from transaction for transactiononline or transactionaccountingline?

It does the quantity x price from the transactionline and stores that in transactionaccountingline. So for example, if you edit a transaction, the code accepting the POST has to update two records per line, not just one.

Unless of course the extension field in transactionaccountingline is seeded by a SQL Function that does that automatically. Which might be a preferred approach for your implementation. The downside of SQL functions though, they tend to be invisible to others maintaining the code.

I don't get it why they remove the full size left and right arrow key?

why you consider full size left and right arrow bad?