Hello, does anybody know if there is some possibility to not have WAL
file as a normal file on the disk, but only in memory? I understand that
all the modifications to the database would get lost in case of the
application / OS crash, but for my application, I only need the level of
durability
Hello Jens and Warren,
Performance is really one of the reasons, second is concurrent writer
and readers (which can be in fact viewed as part of the performance).
Pavel
On 04/04/2018 06:57 PM, Jens Alfke wrote:
On Apr 4, 2018, at 9:01 AM, Warren Young wrote:
Why turn on WAL mode at all,
kpointing" or "like after checkpointing"? I understood checkpointing
as a kind of atomic operation which "merges data in the main database
file and in the WAL". Is that understanding wrong?
Thanks, Pavel
On 04/04/2018 06:33 PM, Dan Kennedy wrote:
On 04/04/2018 09:01 PM, Pa
And how do you change location of the WAL file? Plus, will the main
database file really get corrupted (as in Consistency corrupted, not
only Durability of the data which were in the WAL file) if the OS crashes?
Pavel
On 04/04/2018 07:07 PM, Peter Da Silva wrote:
You could put the WAL in a tm
t"
Which is, as I mentioned not acceptable. Or, it depends, what is meant
by corruption here. As I mentioned, I can loose D from ACID in between
the checkpoints, I need the other ones.
Pavel
On 04/04/2018 07:15 PM, Simon Slavin wrote:
On 4 Apr 2018, at 3:01pm, Pavel Cernohorsky
wrote:
e more familiar with what's
actually possible and actually useful will now rip apart my suggestion.
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Pavel Cernohorsky
Sent: Wednesday, April 04, 2018 10:01 AM
To: sqlite-users@maili
l
On 04/05/2018 09:28 AM, Dan Kennedy wrote:
On 04/05/2018 02:08 PM, Pavel Cernohorsky wrote:
Hello Dan, so you are saying that if WAL is somehow in memory only
(not properly persisted) and app or OS crashes in the middle of the
checkpoint operation, my main database file will get corrupted? A
prompts you to consider these things? Is sqlite
being too slow for you?
On Thu, Apr 5, 2018 at 10:00 AM Pavel Cernohorsky <
pavel.cernohor...@appeartv.com> wrote:
Hello Dan, thank you very much for clearing this up, because that was my
important misunderstanding.
Risking corruption when th
y a very useful thing, so if somebody else needs it as well, here
is the link:
https://www.slideshare.net/SamsungBusinessUSA/using-smart-attributes-to-estimate-enterprise-ssd-lifetime
Pavel
On 04/09/2018 02:47 PM, Simon Slavin wrote:
On 9 Apr 2018, at 8:41am, Pavel Cernohorsky
wrote:
if
9 matches
Mail list logo