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



Reply via email to