Apr-22-2022, 06:03 PM
@ Gribouiilis: keep that Magnetic fluid coming !
I just tested the insert speed, and it is quite a change from SQLite3.
- 8 VARCHAR fields, no index, 550.000 records "committed" into a table
- SSD disk
Average speed = 10.000 records / 12 seconds, almost 10 minutes total.
I need to check but Heidi (!) tells me all the records are there, and shows them.
thx,
Paul
I just tested the insert speed, and it is quite a change from SQLite3.
- 8 VARCHAR fields, no index, 550.000 records "committed" into a table
- SSD disk
Average speed = 10.000 records / 12 seconds, almost 10 minutes total.
I need to check but Heidi (!) tells me all the records are there, and shows them.
thx,
Paul
It is more important to do the right thing, than to do the thing right.(P.Drucker)
Better is the enemy of good. (Montesquieu) = French version for 'kiss'.
Better is the enemy of good. (Montesquieu) = French version for 'kiss'.