3 ms·
The inserts were batched. That was the second thing I tried after getting rid of the index, and that brought it from 20/s to 100/s. This wasn't a website, it w
by jjoonathan 5y ago
The inserts were batched. That was the second thing I tried after getting rid of the index, and that brought it from 20/s to 100/s.
This wasn't a website, it was HPC job tracking. SQLite chugged so hard that the tail wagged the dog, though.
- srcreigh 5y agoI'm not contradicting you, it is curious what you saw, but this SQLite FAQ does claim that 50k/s inserts on a normal computer HDD is possible. Maybe there was some other resource constraint or configuration somewhere. It is very curious. > Actually, SQLite will easily do 50,000 or more INSERT statements per second on an average desktop computer. But it will only do a few dozen transactions per second. Transaction speed is limited by the rotational speed of your disk drive. A transaction normally requires two complete rotations of the disk platter, which on a 7200RPM disk drive limits you to about 60 transactions per second.