Re: [sqlite] Fetch whole result set to memory

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eberhard, Markus (external) wrote: > In other > words: minimize the number of accesses to database file (but I'm not > sure if this is possible). You could use the SQLite backup API to read the entire file into :memory: (quickly and sequentially)

Re: [sqlite] Fetch whole result set to memory

> > Eberhard, Markus (external) wrote: > > I'm using SQLite in my application and I would like to fetch the whole > > result set of a select statement to memory. > > I can't use sqlite3_get_table since it doesn't support BLOBs as far > > as I know. > > Currently I'm using function sqlite3_step

Re: [sqlite] Fetch whole result set to memory

Eberhard, Markus (external) wrote: > I'm using SQLite in my application and I would like to fetch the whole > result set of a select statement to memory. > I can't use sqlite3_get_table since it doesn't support BLOBs as far > as I know. > Currently I'm using

[sqlite] Fetch whole result set to memory

Hi, I'm using SQLite in my application and I would like to fetch the whole result set of a select statement to memory. I can't use sqlite3_get_table since it doesn't support BLOBs as far as I know. Currently I'm using function sqlite3_step to itterate through the result set; that function calls