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
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
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
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
;
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
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
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
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
8 matches
Mail list logo