"About the scenario, there are insert transactions on every 3 seconds. In a busy day, about 3000 rows for big table, another 100 for medium table and around 30 for small table."
There is a question for this sentence "1 row every 3 seconds? Or many rows (3000) every 3 seconds? Very unclear"
So what can be done prevent vagueness here ? And what did you understand from that ?
Edit: Extra info for those who didn't familiar with computer databases. Topic is related to an internet server database.
About the transactions, they don't related with marketing. Simple explanation from wikipedia "A transaction comprises a unit of work performed within a database management system against a database, and treated in a coherent and reliable way independent of other transactions."
Inserts are also about entering data to database. An insert can contain only 1 row or it can contain multiple rows: