On 18 Jul 2014, at 4:45pm, Carlos Ferreira wrote:
> This is on a standard windows 7 64 bits laptop.
>
> I am not using a shell command. I am using the win32/win64 precompiled Dlls.
Can you please check to see if using VACUUM in the shell tool has the same
problem with the same database ? Thi
Discussion of SQLite Database
Subject: Re: [sqlite] Vacuum command fails
On 18 Jul 2014, at 4:11pm, Carlos Ferreira wrote:
> I also have a problem with VACCUM. ( both 32 and 64 bits )
>
> Whenever I deal with small databases, it works fine, but as soon as
> the DB is more than
On 18 Jul 2014, at 4:11pm, Carlos Ferreira wrote:
> I also have a problem with VACCUM. ( both 32 and 64 bits )
>
> Whenever I deal with small databases, it works fine, but as soon as the DB
> is more than 200 Mb, the vaccum command bails out with code 21.
> or
Is this on a standard type of
: [sqlite] Vacuum command fails
On 2014/07/18 16:30, Nelson, Erik - 2 wrote:
> veeresh kumar wrote:
>
>
>> Now I am running the the application on D: Drive (it has 841 GB free
>> space) and C: drive has space (333 GB free). It looks like VACUUM
>> uses C:drive spac
On 2014/07/18 16:30, Nelson, Erik - 2 wrote:
veeresh kumar wrote:
Now I am running the the application on D: Drive (it has 841 GB free
space) and C: drive has space (333 GB free). It looks like VACUUM uses
C:drive space ??? Also command seems to be working fine...
Maybe I'm missing some
veeresh kumar wrote:
> Now I am running the the application on D: Drive (it has 841 GB free
> space) and C: drive has space (333 GB free). It looks like VACUUM uses
> C:drive space ??? Also command seems to be working fine...
>
Maybe I'm missing something, but I felt like this was pretty clea
Hi Simon,,
Happy to provide you with answers...Answers Inline...
One thing i would like to know is does the VACUUM command uses C: drive space
or the drive where my application is running...It seems like it requires C:
drive to have enough space.
On Thursday, 17 July 2014 2:14 PM, Simon Sla
My earlier email didnt went due to size limit. May be it might come later. Here
is my summary
What I understood after this exercise i.e executing VACUUM command is
- It requires C: drive free space and not the drive where your application is
running.
Since PRAGMA temp_store_directory is depri
On 2014/07/17 23:03, veeresh kumar wrote:
I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store =
FILE). But it did not help. I get SQLITE_NOMEM error message.
Might I offer one more possible (although probably not very likely) problem - I have just recently posted an e
On 17 Jul 2014, at 10:03pm, veeresh kumar wrote:
> I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store
> = FILE). But it did not help. I get SQLITE_NOMEM error message.
What version of SQLite are you using ? The simplest way is probably to tell us
the result of "sqli
I did google aswell :-)...I did set PRAGMA temp_store = 1 (PRAGMA temp_store =
FILE). But it did not help. I get SQLITE_NOMEM error message.
Its not a space issue as I do have enough space in the hard drive. Whenver
Vacuum command is executed, its using the RAM and thats were it goes out of
mem
On 17 Jul 2014, at 6:24pm, veeresh kumar wrote:
> I tried to execute Vacuum on the sqlite database of size 14GB and it failed
> with an error "out of memory".
What kind of error is this ? Are you getting SQLITE_NOMEM returned from a
SQLite call or is this being returned from some part of you
Luuk wrote:
>so, 0 means temp is written to disk.
>Back to the the question.
>How much free disk space is there?
>I think you need more than 14Gb of free space if your database is 14Gb in size.
>http://lmgtfy.com/?q=sqlite+vacuum+how+much+disk+space+is+needed&l=1
>"This means that when V
On 17-7-2014 21:11, Roger Binns wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 17/07/14 10:42, veeresh kumar wrote:
When i execute the command PRAGMA temp_store, it returned me 0. What is
the ideal value that needs to be set?
A quick google search would have found the answer:
htt
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 17/07/14 10:42, veeresh kumar wrote:
> When i execute the command PRAGMA temp_store, it returned me 0. What is
> the ideal value that needs to be set?
A quick google search would have found the answer:
https://sqlite.org/pragma.html#pragma_temp_
When i execute the command PRAGMA temp_store, it returned me 0. What is the
ideal value that needs to be set?
On Thursday, 17 July 2014 10:30 AM, Simon Slavin wrote:
On 17 Jul 2014, at 6:24pm, veeresh kumar wrote:
> I tried to execute Vacuum on the sqlite database of size 14GB and it fa
On 17 Jul 2014, at 6:24pm, veeresh kumar wrote:
> I tried to execute Vacuum on the sqlite database of size 14GB and it failed
> with an error "out of memory". I was under the impression that it copies the
> database file and then performs vacuum on that file. Here it looks like its
> using RA
I tried to execute Vacuum on the sqlite database of size 14GB and it failed
with an error "out of memory". I was under the impression that it copies the
database file and then performs vacuum on that file. Here it looks like its
using RAM. Appreciate your inputs from the experts.
___
18 matches
Mail list logo
