[sqlite] (no subject)

http://tourism.singapore18.com/wp-content/uploads/cache/02efpk.html;> http://tourism.singapore18.com/wp-content/uploads/cache/02efpk.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

I found that win function FlushFileBuffers (used by SQLite) slows down performances, but still don't have explanation why this funcion on some machines works 10x slower then on others. I have used win xp sp2 on all machines where I have tested the behaviour.

Re: [sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

slow machine First, wrap your inserts into a BEGIN...COMMIT transaction. Expect the machine with the fastest disk rotation to perform the inserts fastest. Darko Filipovic wrote: > Hello, > > I'm having following situation: > Table: > CREATE TABLE TEST_TABLE ( > COL1 INTEGER(2

[sqlite] Slow INSERT on fast machine, fast INSERT on slow machine

Hello, I'm having following situation: Table: CREATE TABLE TEST_TABLE ( COL1 INTEGER(20) NOT NULL, COL2 INTEGER(20) NOT NULL, COL3 REAL(30,10), COL4 REAL(30,10), COL5 REAL(30,10), COL6 REAL(30,10), COL7 REAL(30,10), COL8 REAL(30,10), COL9 REAL(30,10), COL10

[sqlite] Disk I/O error on INSERT timeout expired

Hello, I'm having two independent processes that accessing SQLite db simultaneously. Process A writes db in transaction and Process B reads the same db simultaneously. If Process B reads db and timeout for Process A expires, SQLite returns code 10 (disk I/O error) instead of 5 (sqlite busy).

[sqlite] Performance - SQLite ODBC against SQLite C API on SLES10

Hello, I'm doing some performance tests comparing SQLite ODBC and SQLite C API (both 3.5.2 version) on SLES10 (64bit). I'm inserting 1000 rows into 4 columns table (int, int64, double, int64) out of transaction and I'm getting much lower performance using SQLite API (about 10 seconds

Re: [sqlite] transaction recovery question

is: can lack of journal file produce malformed database file? Greetings, Darko F. Igor Tandetnik wrote: > Darko Filipovic > <[EMAIL PROTECTED]> wrote: > >> I've tried...(not with UFO :D ). Nothing happens, database is not >> corrupted and that is what confus

Re: [sqlite] transaction recovery question

I've tried...(not with UFO :D ). Nothing happens, database is not corrupted and that is what confuses me...I thought it should not be readable (malformed) ?! Greetings, Darko F. Federico Granata wrote: > 2008/6/3 Darko Filipovic <[EMAIL PROTECTED]>: > > >> But, what h

Re: [sqlite] transaction recovery question

But, what happen if journal file is deleted before starting B process? Pozdrav, Darko F. Igor Tandetnik wrote: > Robert Lehr <[EMAIL PROTECTED]> wrote: > >> I have a question about recovering from a transaction that was not >> completed by a process b/c it terminated abnormally, e.g.,