Load existing db file to memory Python sqlite?

Question

I have an existing sqlite db file, on which I need to make some extensive calculations. Doing the calculations from the file is painfully slow, and as the file is not large (~10 MB), so there should be no problem to load it into memory.

Is there a way in Python to load the existing file into memory in order to speed up the calculations?

what about : https://stackoverflow.com/questions/2887878/importing-a-csv-file-into-a-sqlite3-database-table-using-python#2888042 — jmunsch, Dec 07 '17 at 19:35

score -2 · Accepted Answer · answered Dec 07 '17 at 19:33

-2

You could read all the tables into DataFrames with Pandas, though I'm surprised it's slow. sqlite has always been really fast for me.

answered Dec 07 '17 at 19:33

SuperStew

2,857
2
15
27

Load existing db file to memory Python sqlite?

1 Answers1