Improve insert performance

roskakori / pimdb

build a database from IMDb datasets

https://pypi.org/project/pimdb/

BSD 3-Clause "New" or "Revised" License

7 stars 1 forks source link

Closed roskakori closed 4 years ago

roskakori commented 4 years ago

Goals:

[x] Existing bulk inserts for command transfer do not perform intermediate commits.
[ ] If possible inserts for command build use SQL insert from select instead of Python loops.
[ ] The remaining inserts for command build use bulk inserts.