After almost a year I am at 18 TBW on my system/data SSD and that includes
several re-installs of Windows plus a bunch of VM updates of the Windows
"Insider" previews, so getting to 1200 TBW would be quite a task ... (Note,
defrag does not run on SSDs since it is useless, but I have forced
On Mon, Jun 18, 2018 at 9:15 PM, Patrick Herbst wrote:
> I'm using sqlite in an embedded application, running on SSD.
>
> journal_mode=persist
> so that it is more resilient to loss of power.
>
> I'm seeing corruption. I'm using sqlite to log events on the system,
> and the corruption is well in
Between updates, automatic maintenance, registry churn, event logs, and
background "optimisations" I reckon windows could give 400G/day a run for
its money :P
-Rowan
On 19 June 2018 at 12:37, Keith Medcalf wrote:
>
> The new "consumer" SSDs from Samsung carry a 1200 TBW/8 year warranty on a
>
The new "consumer" SSDs from Samsung carry a 1200 TBW/8 year warranty on a 4 TB
device. That is a lot of writing for a "consumer desktop" computer ... that is
about 400 GB written per DAY every day for 8 years!
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
SSD's have a limited number of write cycles. You may have a
failing SSD. Those are still, IMO, another 5-10 years before
they solve the write lifetime reliabilty issue.
-
Scott Doctor
sc...@scottdoctor.com
-
On 6/18/2018 20:15, Patrick Herbst
I'm using sqlite in an embedded application, running on SSD.
journal_mode=persist
so that it is more resilient to loss of power.
I'm seeing corruption. I'm using sqlite to log events on the system,
and the corruption is well in the middle of a power session; not at
the tail end of log when a
Check out:
http://c.qyv.net/mailmansrc/info/a6250b7ba075294c
This is a patch to mailman version 2.1.20 (the version deployed on
sqlite.org). It adds a three day waiting period between subscription
attempts. When applying this patch also be sure to edit Defaults.py (which
is generated at
Many thanks Simon, Keith and Richard for your attention and didactic
explanations.
Em 17-06-2018 14:37, Keith Medcalf escreveu:
Also note that you probably want your application to store the password as a
salted-hash, and not as a plain-text password. Otherwise someone could look up
the
The following pure python code does the same thing, memmapping the file when
reading backwards ... works in Python 2 and 3, 32 and 64 bit.
Emulates what sqlite3 is doing as closely as I can manage. As long as the mmap
fits in memory it does not seem to affect performance.
---//---
from
These are with SQLITE3's memmap turned off (SQLITE_DEFAULT_MMAP_SIZE 0). I set
the MAX_SIZE to 0 as well and it made no difference.
Windows is memmapping the file by itself.
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
I haven't grasped all the fancy memory talk that's been going on here, but I
have one request. Would you try the slowdown tests with a SQLite version
compiled with...
SQLITE_DEFAULT_MMAP_SIZE=0
SQLITE_MAX_MMAP_SIZE=0
...and see if anything changes? I started compiling with those options after
Thanks Guy. After reading that I was wondering if it was maybe something to do
with the code I’ve added to the end of the sqlite3.c file which includes
several extentions. After commenting out the #include “csv.c” (& associated)
code it linked OK.
From:
On Jun 18, 2018, at 3:21 AM, x wrote:
> I’m using c++ builder 10.2 Tokyo on windows 10 pro.
> In a console app I’m getting this error message
>
> [ilink32 Error] Error: Unresolved external '___fixunsdfdi' referenced from
> C:\...\PROJECTS\WIN32\DEBUG\SQLITE3.OBJ
>
> I can’t find any mention
Any thought, comments, or observations of using Slack?
On Fri, Jun 15, 2018 at 1:25 PM J. King wrote:
> On June 15, 2018 12:17:31 PM EDT, dmp
> wrote:
> >> Mailing lists are now back on-line and once again accepting
> >> subscriptions. I have implemented measures to block the subscription
>
I’m using c++ builder 10.2 Tokyo on windows 10 pro.
In a console app I’m getting this error message
[ilink32 Error] Error: Unresolved external '___fixunsdfdi' referenced from
C:\...\PROJECTS\WIN32\DEBUG\SQLITE3.OBJ
I can’t find any mention of it in sqlite3.h or sqlite3.c.
Anyone know anything
15 matches
Mail list logo