I have a table. Due to the nature of the website, in that table, if i have 400+ users or so, it will have in it inserted 100,000 new rows per hour.
If i have near 4000 then for 2 hours or so, i will have a minimum of 500,000 rows inserted. This means about 800-1000 inserts per second, probably even way more than that.
How do i prepare the table for such intense use? I am talking about quite the lot of inserts per second in the table and i don't want it to get locked or slow down.
The table engine is MyISAM, but it could be altered to accommodate any changes