a href=http://tourism.singapore18.com/wp-content/uploads/cache/02efpk.html;
http://tourism.singapore18.com/wp-content/uploads/cache/02efpk.html/a
___
sqlite-users mailing list
sqlite-users@sqlite.org
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.
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(20) NOT NULL,
COL2 INTEGER(20
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
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).
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
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 confuses me...I thought it should not be
readable
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 happen if journal file
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., careless
