[sqlite] multiple Db's and journal file time hit?

Hello Recently it was written: whenever a modifying transaction starts (or rather, when it has to actually write data to disk for the first time), SQLite has to create a journal file for each DB involved as well as a master journal file. We are testing (almost ready to purchase the $180 COM

re: [sqlite] multiple Db's and journal file time hit?

I think I've confused the issue a bit and the aforementioned time hit might be normal given: http://www.sqlite.org/lockingv3.html We are using a separately developed COM DLL interface to Sqlite v3: http://www.sqliteplus.com/ And we can live with the journal creation time if that is what it is

Re: [sqlite] multiple Db's and journal file time hit?

The delay seems to coincide with the journal file creation-- it happens after our first (committed but not yet written to disk) write attempt to the database, the journal file does not at-the-time exist, and there are 500+ inserts pending with reads rapidly being added after that. Although I to

Re: [sqlite] multiple Db's and journal file time hit?

Yes the timestamp method is one we have done from within our own code and it may very well be the operating system catching up to where it should be and not the database's fault at all. It hangs on a read after the inserts--- ourDB.Exec("Select x From Y where x.HashCode = z LIMIT 1;"). (where

re: Re[2]: [sqlite] multiple Db's and journal file time hit?

; Subject: Re[2]: [sqlite] multiple Db's and journal file time hit? Hello sales, What are you using for a data structure? I regularly have literally millions of hashed data structures in memory without encountering this. If it's windows, I know exactly what it is though, windows pages th

re: [sqlite] VB.Net

We did try one wrapper designed for .NET but it's setup program didn't set itself up right on our system and I didn't have the time to mess with it. We do use this and it works great: http://www.sqliteplus.com/ It's a COM interface to a sqlite DLL. It's a little pricey at $180 but that includ

re: [sqlite] multiple Db's and journal file time hit?

Thank you for the idea! Tom From: Eduardo <[EMAIL PROTECTED]> Sent: Tuesday, December 20, 2005 11:21 AM To: sqlite-users@sqlite.org Subject: re: [sqlite] multiple Db's and journal file time hit? At 17:17 19/12/2005, you wrote: >I think I've confused the

[sqlite] How to unsubscribe?

Hello, When I visit http://www.sqlite.org/support.html there is plenty of information about joining this list but nothing about how to unsubscribe. Anyone know how to do that? Thanks, Tom