[odb-users] SQLite writing during select

Tony Rietwyk tony at rightsoft.com.au
Wed Apr 6 21:50:54 EDT 2016


Hi Andrew, 

It looks like SQLite is using temporary tables to sort the items.  It should have settings to redirect the sorting to another location, if the database is read-only.  

Hope that helps, 

Tony

> Sent: Thursday, 7 April 2016 6:16 AM
> 
> I am doing some performance tuning (profiling opening a 9GB file) and I am
> confused as to why appears SQLite is writing to the database while
> essentially I am reading the database file while  loading a
> std::vector<std::shared_ptr<> >
> 
> Any insights would be helpful.
> 
> 
> 
>   odb-sqlite-2.4-vc12.dll!winWrite(sqlite3_file * id, const void * pBuf,
> int amt, __int64 offset) Line 36373    C
>      odb-sqlite-2.4-vc12.dll!vdbeSorterListToPMA(SortSubtask * pTask,
> SorterList * pList) Line 80821    C
>      odb-sqlite-2.4-vc12.dll!vdbeSorterFlushPMA(VdbeSorter * pSorter) Line
> 80961    C
> >    odb-sqlite-2.4-vc12.dll!sqlite3VdbeExec(Vdbe * p) Line 76730    C
>      odb-sqlite-2.4-vc12.dll!sqlite3Step(Vdbe * p) Line 70730    C
>      odb-sqlite-2.4-vc12.dll!sqlite3_step(sqlite3_stmt * pStmt) Line
> 70791




More information about the odb-users mailing list