Re: [sqlite] SQlite 3 - bottleneck with rbuFindMaindb

2018-09-21 Thread Roger Cuypers
sqlite3Step sqlite3_step > Am 19.09.2018 um 22:27 schrieb Simon Slavin : > > On 19 Sep 2018, at 8:47pm, Roger Cuypers wrote: > >> the database has a root file. The subfiles are all loaded via separate >> connections as far as I know. > > Sorry, but this makes no

Re: [sqlite] SQlite 3 - bottleneck with rbuFindMaindb

2018-09-19 Thread Roger Cuypers
ieb Simon Slavin : > > On 19 Sep 2018, at 7:49pm, Roger Cuypers wrote: > >> As far as I know it uses journaling with WAL and has a lot of files/tables >> (about 400). > > Excuse the low-end questions, but they might help save us a lot of silly > sugges

Re: [sqlite] SQlite 3 - bottleneck with rbuFindMaindb

2018-09-19 Thread Roger Cuypers
0/2018 01:49 AM, Roger Cuypers wrote: >> I'm trying to optimize a C++ application that uses sqlite 3 for database >> access. As far as I know it uses journaling with WAL and has a lot of >> files/tables (about 400). Profiling this application with Linux perf, I >> found tha

[sqlite] SQlite 3 - bottleneck with rbuFindMaindb

2018-09-19 Thread Roger Cuypers
I'm trying to optimize a C++ application that uses sqlite 3 for database access. As far as I know it uses journaling with WAL and has a lot of files/tables (about 400). Profiling this application with Linux perf, I found that it spends about 30% of its time inside the rbuFindMaindb function of