Jérôme VERITE, dando pulos de alegria, escreveu :
I use Sqlite with file databases and I’m wondering if it is possible to load
the totality of this db in memory to perform requests.
I saw I can specify :memory: for the filename but by this way, I can’t laod
my file database in memory. So the question is very simple
How can I load the totality of a file database in memory?
1) open a ":memory:" database;
2) "ATTACH" your disk database;
3) copy your file database tables to your memory database;
4) "DETACH" your disk database.
Regards,
~Nuno Lucas