Is it possible to load SQLite db in to memory and execute query?

Question

I am programing under C++, windows, I want to retrieve all content in SQLite DB, so I make use of "select * from XXX", The DB is about 4M, However if the system restarted, the first time query will be really time consuming. I want to load the db file into memory, and execute select * from XXX in memory. Is it possible to do it? Many thanks!

BastiBen · Accepted Answer · 2010-11-25 02:54:38Z

1

Technically the database is loaded into memory when you open it. But you can have pure memory-based databases, too. In that case use :memory: as the path when opening the database.

Hope that helps. :)

answered Nov 25, 2010 at 2:54

BastiBen

20k11 gold badges59 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Benoit · Accepted Answer · 2010-11-25 08:19:27Z

0

you could still do the following:

sqlite database < script

with script containing:

.output dump.sql
.dump
.output.stdout

then start an SQLite shell w/o any argument, and do .read 'dump.sql'

answered Nov 25, 2010 at 8:19

Benoit

79.7k24 gold badges226 silver badges241 bronze badges

Collectives™ on Stack Overflow

Is it possible to load SQLite db in to memory and execute query?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related