Re: Up to 50K inserts per second... smokin'!

On 8/25/2021 7:26 PM, Jerry Stuckle wrote:
> On 8/25/2021 2:07 PM, DFS wrote:
>> Copying 30M rows (across 15 tables) from SQLite into a MariaDB store

> And BTW - with so many rows you'd probably get even better response by 
> DROPping any indices before the INSERT and recreating them after the 
> INSERT.


Created an Oracle Express 18c database and created 'skeleton' tables 
with no PKs or FKs or indexes of any kind.  Just table, column name, 
datatype and NOT|NULL spec.

TBL 1:   14.88 secs to post  2799305 rows (188096 per sec)
TBL 2:   21.93 secs to post  3568564 rows (162707 per sec)
TBL 3:  110.49 secs to post 14898302 rows (134840 per sec)