Database Administrators Asked by 2alltra8034 on October 28, 2021
I am looking for advice on a database to potentially replace SQLite for my application.
To briefly describe my DB requirements:
The only problem i have so far is the speed of importing new data sets into my DB, which i only need to do infrequently and manually. It has gotten very slow if not impossible to import data with the current amount of records (15 million) due to the indexing. This leaves me two options for SQLIte inserts:
Spread the data across thousands of SQLite tables – added complexity and i believe this would all need to be custom coded in my app
Drop indexes -> insert new data -> re-create indexes – also quite slow
Could PostgreSQL or another relational DB offer fast inserts with multiple indexed columns up to 100 million + rows?
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP