Re: [sqlite] pragma synchronous=off and journal_mode=wal still syncs to disk

the cpu and disk I/O patterns which led me to think that a sync was being done, so it must be some issue specific to the first host unrelated to Sqlite. Thanks for your response! Bob From: Richard Hipp <d...@sqlite.org> To: Bob Price <rjp_em...@

[sqlite] pragma synchronous=off and journal_mode=wal still syncs to disk

It appears that regardless of a "pragma synchronous=off" that there are still syncs to disk done at key points in WAL mode such as in a "pragma wal_checkpoint(RESTART)".  I think that this is true based on the application cpu and disk I/O patterns I observe when logging shows the wal checkpoint

[sqlite] 5 readers, 1 writer, shared cache and read uncommitted - repost

I asked this last Friday evening (which probably wasn't a good time) and didn't get any responses, so I thought I would try one more time.  I apologize for the duplication. This is a question to ask about a particular Sqlite usage configuration to see if it is appropriate or how to make it

[sqlite] 5 readers, 1 writer, shared cache and read uncommitted

This is a question to ask about a particular Sqlite configuration to see if it is appropriate or how to make it better. A brief sketch of the processing need is that I have one process managing a lot of "item" data in a Sqlite db, and occasionally there is a need to walk through all items and

Re: [sqlite] performance of one process using multiple independent sqlite databases

this question to this group. I appreciate everyone's help.  I will continue to debug and experiment and any advice is welcome! Bob From: Keith Medcalf <kmedc...@dessus.com> To: Bob Price <rjp_em...@yahoo.com>; General Discussion of SQLite Database &

Re: [sqlite] performance of one process using multiple independent sqlite databases

Yes, I have run this on SSD drives and on a ram disk where disk IO wasn't a limited factor. Bob From: Simon Slavin <slav...@bigfraud.org> To: Bob Price <rjp_em...@yahoo.com>; General Discussion of SQLite Database <sqlite-users@sqlite.org&g

[sqlite] performance of one process using multiple independent sqlite databases

I've been searching through the archive without much luck on this topic, so I'll ask my question.  If this has been answered somewhere else please point me to that. I have a single process that independently opens and uses multiple Sqlite databases, each with its own connection.  The data in