On 09/26/2012 05:48 AM, Simon Slavin wrote:
On 25 Sep 2012, at 10:54pm, David Barrett
wrote:
If my database is X GB, and the WAL file is Y GB, how much total
disk space is required to:
1) Checkpoint the database
I think it's a maximum of X+Y+Y (including the
Do you think a retry of the query would help resolve this issue ? Do I have to
close & reopen the database.
Thanks for your help.
regards,
Rittick
___
sqlite-users mailing list
sqlite-users@sqlite.org
Yes, still having that problem. We've moved to new servers with SSD's and a
ton of RAM, and that seems to have helped matters -- not sure why, though I
don't know why it was happening in the first place. (I'm *guessing* the
issue is due to two conflicting queries happening at the same time, so if
David,
Thanks. Do you still have the problem ? Did you find a workaround to
avoid the problem - appreciate your response.
regards,
Rittick
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 25 Sep 2012, at 10:54pm, David Barrett wrote:
> If my database is X GB, and the WAL file is Y GB, how much total disk space
> is required to:
>
> 1) Checkpoint the database
I think it's a maximum of X+Y+Y (including the existing X+Y) plus or minus a
page or two.
>
If my database is X GB, and the WAL file is Y GB, how much total disk space
is required to:
1) Checkpoint the database
2) Vacuum the database
Additionally, if there are any temporary files created, where do they
exist? We've done some poking around and are having some crazy theory
about a
You might be interested in this thread:
http://www.theusenetarchive.com/usenet-message-sqlite-does-disabling-synchronous-and-shared-cache-cause-%22error-database-disk-image-is-malformed%22-20780199.htm
No conclusion was ever obtained, but the discussion was good.
-david
On Mon, Sep 24, 2012 at
LacaK wrote:
> But why not add %y, when it is only 5 lines of source code,
Plus documentation, test cases, etc.
> take into account that %y is supported also by C strftime()
> or PHP etc.
Those languages are not called Clite or PHPlite.
> and it is really useful.
You still haven't mentioned a
Yes I know, that there is workaround using:
substr(strftime('%Y',d),3)
But why not add %y, when it is only 5 lines of source code, take into account
that %y is supported also by
C strftime() or PHP etc. and it is really useful.
-Laco.
Seriously, what your patch is actually about is to
LacaK wrote:
> some month ago I wrote question about possibility to add support of %y
> (2 digit year) to strftime() function.
> Patch is very simple (only few lines of code) and I hope, that will be
> useful for many users.
Two-digit years happend about two thousand years ago, and at that time,
Please can any developer do any comment on this request?
Would it be possible to add such support?
Thanks
-Laco.
- Pôvodná správa -
Predmet:[FEATURE REQUEST] support of %y in strftime()
Dátum: Fri, 21 Sep 2012 14:15:45 +0200
Od: LacaK
Pre:
11 matches
Mail list logo