Richard,
Thanks for the comprehensive update.
We appreciate that there are tradeoffs and that dropping a table is a
rarer operation than most others. The upside of the Sqlite design is
that we treat a database as a single file which we copy around with
ease. You cannot do that with many other
Jay,
I think your approach would have been quicker. Ten hours so far and it's
still deleting the table :(
Rob
On 17 Jul 2018, at 2:16, Jay Kreibich wrote:
On Jul 16, 2018, at 3:01 PM, rob.sql...@robertwillett.com wrote:
Hi,
We're doing a massive tidy on our database which is approx 50GB.
> On Jul 16, 2018, at 3:01 PM, rob.sql...@robertwillett.com wrote:
>
> Hi,
>
> We're doing a massive tidy on our database which is approx 50GB.
>
> One table is approx 49GB of that 50GB which we need to delete as we have
> recorded the information in a far better format thats approx 99% more
On 7/16/18, Rob Willett wrote:
>
> It does look as if one of sqlite's weaknesses is dropping very, very
> large tables.
>
Right. If every table were stored in a separate file, a DROP TABLE
could be translated to a relatively fast unlink(). But then a
database would be a directory full of files,
Mmm It's still taking an awful long time, though the -wal file is
very small.
It does look as if one of sqlite's weaknesses is dropping very, very
large tables.
Oh well, lets let it run through the night.
Rob
On 16 Jul 2018, at 21:25, Rob Willett wrote:
Dan,
We've killed the process
Dan,
We've killed the process (kill -9). Fired up sqlite3 again, closed it
down normally. The -wal files were removed.
Fired up sqlite3 again, turned off secure_delete, started to drop the
table again, reniced it down (long story to do with IOPS and our VPS
provider)
-wal file is empty, th
On 07/17/2018 03:12 AM, Rob Willett wrote:
Dan,
Thanks for the reply.
pragma secure_delete;
1
sqlite>
Which is a bit of a surprise as we have never seen it before. We had to
look it up using your reference.
No idea why that is set (if 1 means it is).
Should we simply ctrl-C the deletion, tur
Dan,
Thanks for the reply.
pragma secure_delete;
1
sqlite>
Which is a bit of a surprise as we have never seen it before. We had to
look it up using your reference.
No idea why that is set (if 1 means it is).
Should we simply ctrl-C the deletion, turn secure_delete off and then
try again? M
On 07/17/2018 03:01 AM, rob.sql...@robertwillett.com wrote:
Hi,
We're doing a massive tidy on our database which is approx 50GB.
One table is approx 49GB of that 50GB which we need to delete as we have
recorded the information in a far better format thats approx 99% more
efficient. If only we h
Hi,
We're doing a massive tidy on our database which is approx 50GB.
One table is approx 49GB of that 50GB which we need to delete as we have
recorded the information in a far better format thats approx 99% more
efficient. If only we had been this clever when we started
We've just 'dropp
Hi All,
Intermittently application throws below exception, the application is
configured to run on *32-bit mode.*
Used version of the dll is latest *1.0.108.0 *as per
https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
It appeared to me bug, can some one confrim?
System.*Entr
11 matches
Mail list logo