Yes! The journal file was indeed there. I deleted it before openning the
database, and read 50 records. I repeated the process; it's consistent.
The way I see it that even though the synchronous setting is FULL, there is
no API to tell the OS to physically delete a file from disk, just like
there
On 09/10/2012 03:15 AM, Daniel Frimerman wrote:
My apologies about the attachment; should have known better.
This should be better:
https://dl.dropbox.com/u/50838941/SQLite3_Test.zip
I only get the problem with DELETE and TRUNCATE journal_mode (synchronous
set to NORMAL or FULL), but not with PE
Actually, I am not using sqlite at the API level. That's why prepared a
bunch of batch files that reproduce the issue with sqlite command line
shell. To answer your question, the queries complete in sqlite3 command
line, and they also complete successfully using the API, albeit, through a
wrapper
On 9 Sep 2012, at 9:15pm, Daniel Frimerman wrote:
> The reason I think there has to be 50 rows is because on FULL mode for
> example, the I/O buffers are flushed, and it's consistently missing 1
> record as opposed to any other number of records. I insert 50 records, the
> sqlite3 command line u
My apologies about the attachment; should have known better.
This should be better:
https://dl.dropbox.com/u/50838941/SQLite3_Test.zip
I only get the problem with DELETE and TRUNCATE journal_mode (synchronous
set to NORMAL or FULL), but not with PERSIST (synchronous set to NORMAL or
FULL) or WAL (
Note: attachments are stripped out of this list. So if you want for
anybody else to see your zip file you need to put it on some website
and post link here.
About the problem you have: I wonder how are you sure that there
should be 50 rows in the database and not 49? If you are resetting the
OS be
I am fairly new to sqlite and as a result of not reading the manual and not
doing some performance testing, I got punished somewhat. I did not
anticipate that on journal_mode=DELETE and synchronous=FULL, I would get no
more than 5 inserts (in auto-commit mode) per second. It crippled a
certain ba
7 matches
Mail list logo