I compiled up your code and ran it on Windows using VC6 and got:
a
98
Hope this helps
Dan
-Original Message-
From: Marco Bambini [mailto:[EMAIL PROTECTED]
Sent: 31 October 2007 09:33
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version
No, the d
] [mailto:[EMAIL PROTECTED]
Sent: 30 October 2007 17:15
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Your Concurrency Idea
"Dan Petitt" <[EMAIL PROTECTED]> wrote:
> Richard, i noticed this ticket in the system:
> http://www.sqlite.org/cvstrac/tktview?tn=2417,8
&g
Richard, i noticed this ticket in the system:
http://www.sqlite.org/cvstrac/tktview?tn=2417,8
And wondered if its something that is getting any serious thought or
something that is just a faint possibility?
-
To unsubsc
> Alternatively, you don't actually need the interface for 99.99% of users
out there (Windows, Linux, Mac)
> so you could make it unnecessary for them, but do require it for the
various esoteric embedded systems.
> That would justify still calling it SQLite version 3.
That was my first thought, ju
I had a similar problem, importing a lot of data into a database (import
very infrequently but read a lot) and then accessing it. With about 6million
rows it was taking 12 hours to get halfway through importing so I gave up.
These are the things that massively helped me:
* Increased default_page_c
I think (looking at the source) that it's a pragma, but I don't know when
you set it, once when DB is opened, on each write or on each read.
You are the third to ask (including me), maybe Richard or someone else can
through some light on it for us.
____
Hi
I searched the mail archive and documentation but could not find any
'answer' to the new "READ UNCOMMITTED" ability.
Is it a pragma? If it is; is it set when database is opened, or each time
you start a write transaction, or maybe something else?
Any assistance would be appreciated, thanks
Da
> Isolation in SQLite is SERIALIZABLE. Note that SERIALIZABLE
> implies that locking can be no more fine-grained than table-level.
> You can obtain table-level locking in SQLite now. Just put each
> table in a separate database file and ATTACH as many tables to
> your connection as you require.
> Does your flat file support ACID transactions? That´s the killer feature
fo
> my app. I want to store financial transactions and I don´t trust normal
flat
> files.
No it isnt acid, its not got critical information in it but it does need
very fast read access and write access that doesnt block re
currently are able to.
Thanks for your time.
Dan Petitt
10 matches
Mail list logo
