Insert and select same table or separate

[Anon]

I have that table where user register sales and at the same time they can see its actual number of products sales. To do so they insert sales in sales_table and to generate the report the php script selects the products they have sale from that same table. Now, will it give the sales_table less load? to insert the sales in two tables at the same time and then use one just to register sales and the other (that would be a copy) to generate the reports?

[[deleted]]

"Now, will it give the sales_table less load? "

that depends on what kind of queries you run, and what kind of database engine you have.

For example: in the 'old' MySQL, every INSERT query would cause a table-level-lock. That means, every time an INSERT was executed, the entire table became unreadable to everybody else until that insert query was finished. In that case, using a seperate table will be faster.
But if you are not using table-level-locks, then it makes no difference at all. (and remember, making the copy of the table also takes time!)