Answer the question
In order to leave comments, you need to log in
Incommensurable size of the SQLite database file with the source data. How to decide?
Good afternoon.
Tell me how to overcome SQLite to reduce the size of the database.
The situation is as follows:
We have initial text data of the csv type with a "tab" separator.
The original file takes up 281 MB of disk space. I transfer the file with all fields to the SQLite DB, adding only 1 field (id, integer, autoincrement) and I get the size of the DB file on disk: 677 MB.
What could be the reason for this growth? How is it possible to overcome it? For there will be a lot of data and such growth scares me.
I must say right away that I checked for duplication of records. Not duplicated - the number of lines in the file corresponds to the number of records in the database table.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question