I'm really confused because this table doesn't even have any foreign keys or external references, only a handful of columns, and the primary key is just an incrementing integer. this is just a normal use case, but inserting 200 rows via batch insert takes upwards of 4 or 5 seconds. I purged the table and did the same insert and it still took about 700ms.
this use case may be better suited to Cassandra but that's not what we have today right now