On 7/27/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
Also, consider running that Task Manager and enable all the column
statistics (I/O, threads, VM Faults, Page Faults, etc) to see what's
going on while you're running your software. You never know what crazy
process might be screwing up your
--- Jens Miltner <[EMAIL PROTECTED]> wrote:
> Am 26.07.2006 um 04:16 schrieb Joe Wilson:
> > In order to isolate some variables, what results do you get
> > with the default ./configure && make on both platforms?
> > (default is temp store = file, non-threadsafe).
>
> We explicitely define the
On Wed, 26 Jul 2006 20:56:16 +0200, you wrote:
>Because sqlite has to deal with so many platforms, it shouldn't
>make as few assumptions as possible about the 'correctness' ...
Oops, that should of course read:
Because sqlite has to deal with so many platforms, it should
make as few assumptions
On Tue, 25 Jul 2006 23:13:31 +0200, you wrote:
>Hi,
>
>we just found that when using file-based temporary storage (compile
>time macro definition TEMP_STORE=1) vs. memory-based temporary
>storage (TEMP_STORE=2), on Mac OS X, the performance almost doesn't
>degrade at all, whereas on
On Wed, 26 Jul 2006 15:23:04 +0100 (BST), you wrote:
>Looking at this reminded me. What is the point of deleting the rollback
>log? Why not just truncate it when committing a transaction, and deleting
>it only when closing the database?
My guess:
Because sqlite has to deal with so many
[EMAIL PROTECTED] uttered:
Jens Miltner <[EMAIL PROTECTED]> wrote:
OTOH, our customers might also have antivirus software installed, so
this still would not be a solution :(
Does anybody have advice on how to make sqlite work smoothly with
antivirus software [on Windows]? (Probably depends
Am 26.07.2006 um 15:41 schrieb [EMAIL PROTECTED]:
Jens Miltner <[EMAIL PROTECTED]> wrote:
OTOH, our customers might also have antivirus software installed, so
this still would not be a solution :(
Does anybody have advice on how to make sqlite work smoothly with
antivirus software [on
Jens Miltner <[EMAIL PROTECTED]> wrote:
>>
> OTOH, our customers might also have antivirus software installed, so
> this still would not be a solution :(
> Does anybody have advice on how to make sqlite work smoothly with
> antivirus software [on Windows]? (Probably depends on the antivirus
Am 26.07.2006 um 04:16 schrieb Joe Wilson:
According to the documentation in http://sqlite.org/pragma.html
for PRAGMA temp_store, it seems that only the TEMP_STORE macro
values of 0 and 3 unconditionally guarantee temporary storage
to be file and memory respectively. Otherwise the runtime
Are you running Windows anti-virus software?
--- Jens Miltner <[EMAIL PROTECTED]> wrote:
> Hi,
>
> we just found that when using file-based temporary storage (compile
> time macro definition TEMP_STORE=1) vs. memory-based temporary
> storage (TEMP_STORE=2), on Mac OS X, the performance
According to the documentation in http://sqlite.org/pragma.html
for PRAGMA temp_store, it seems that only the TEMP_STORE macro
values of 0 and 3 unconditionally guarantee temporary storage
to be file and memory respectively. Otherwise the runtime
"PRAGMA temp_store=FILE|MEMORY" plays a role.
Hi,
we just found that when using file-based temporary storage (compile
time macro definition TEMP_STORE=1) vs. memory-based temporary
storage (TEMP_STORE=2), on Mac OS X, the performance almost doesn't
degrade at all, whereas on Windows, we're getting a huge performance
penalty when
12 matches
Mail list logo