I run the SQL Anywhere DBMS, and we have a table of about 10 columns(normal text, timestamps etc). However, in my use-case, every single day, the table gets 2160000 new rows. It's also crucial that new inserts to the db takes less than 3ms.
I'm in the design phase, so the database isnt in use yet. Question is, should I put everything into one table? Or should I design my system from the start to use multiple tables, divided by for instance days? (Will this improve performance, since I'm having smaller tables?)