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 almost
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. (Am
Nuno Lucas wrote:
On 7/22/06, Eduardo <[EMAIL PROTECTED]> wrote:
Sorry, but i must disagree. He uses VC6, a compiler from
pre-alot-of-processor-advances. So, the compiler can't, not only
compile for a more modern and different processor (different
pipeline, sse, new processor modes, etc..) but
Chunde Shi
[EMAIL PROTECTED]
703 882 1466
703 882 2325
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tue 7/25/2006 7:06 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite3_interrupt() and threads
Michael Scharf <[EMAIL PROTECTED]> wrote
Michael Scharf <[EMAIL PROTECTED]> wrote:
> Rob,
> > I notice in the documentation that the sqlite3_progress_handler() method
> > is marked "experimental". Is that significant?
>
> No idea, that's a question Richard Hipp may answer..
>
I need to remove the experimental marking. Perhaps
somebod
On 7/22/06, Eduardo <[EMAIL PROTECTED]> wrote:
Sorry, but i must disagree. He uses VC6, a compiler from
pre-alot-of-processor-advances. So, the compiler can't, not only
compile for a more modern and different processor (different
pipeline, sse, new processor modes, etc..) but also use old librari
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 usin
At 02:10 22/07/2006, you wrote:
Michael,
The guy who produced Sqlitespy is a member of this forum so he can
confirm or debunk my theory as to why you are getting a big
difference in execution time. I suspect that Sqlitespy might be
storing the SQL in its compiled (from sqlite3_prepare) form
If you want to use that POSIX record locking, use a flat file. Then you
can lock a section of it. A DBMS like Sqlite is a web of linked records
and shares the structures which maintain the links. Row and table
locking requires other structures.
Since Sqlite is a library, not a server, and y
So, is imposible to read alway and write one per time... ?
On 7/25/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
I just want to read always and write one time.. understand? is that
imposible?
On 7/25/06, Robert Simpson <[EMAIL PROTECTED] > wrote:
>
> > -Original Message-
Jay Sprenkle wrote:
On 7/25/06, John Stanton <[EMAIL PROTECTED]> wrote:
Martin Jenkins wrote:
> John Stanton wrote:
>
>> I used to have one but I had to shoot it when it went feral.
>
> As a puppy?
>
No, not until instead of just chasing cars it started catching and
eating them.
Wouldn't th
I just want to read always and write one time.. understand? is that
imposible?
On 7/25/06, Robert Simpson <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 25, 2006 8:07 AM
> To: sqlite-users@sqlite.org
>
On 7/25/06, John Stanton <[EMAIL PROTECTED]> wrote:
Martin Jenkins wrote:
> John Stanton wrote:
>
>> I used to have one but I had to shoot it when it went feral.
>
> As a puppy?
>
No, not until instead of just chasing cars it started catching and
eating them.
Wouldn't that be 'cacheing' them a
Martin Jenkins wrote:
John Stanton wrote:
I used to have one but I had to shoot it when it went feral.
As a puppy?
mj
No, not until instead of just chasing cars it started catching and
eating them.
Martin Jenkins wrote:
Jay Sprenkle wrote:
what's a CRUD?
I wondered that too. h
On 7/25/06, Ralf Deininger <[EMAIL PROTECTED]> wrote:
I have a multi-threaded application. Each thread has its own database
connection. One of the thread changes the schema of the database (DROP
TABLE, CREATE TABLE). I have observed that the other threads do not know
about these modifications si
> -Original Message-
> From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 25, 2006 8:07 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Sqlite Write and read a the same time
>
> Hello!
>
> The weekend I was reading a book "Programming in Linux" and I f
Rob,
I notice in the documentation that the sqlite3_progress_handler() method
is marked "experimental". Is that significant?
No idea, that's a question Richard Hipp may answer..
Michael
--
http://MichaelScharf.blogspot.com/
Hello!
The weekend I was reading a book "Programming in Linux" and I found
something for me very cool!. I so that you could Lock a File for write but
just a part of the file. And I am wondering if in Linux SQLite would be able
to lock just a Page of the B-tree when you are doing the insert and th
Michael,
I notice in the documentation that the sqlite3_progress_handler() method
is marked "experimental". Is that significant?
Rob
Great! That looks like exactly what I need.
Thanks very much!
Rob Richardson
RAD-CON INC.
-Original Message-
From: Michael Scharf [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 25, 2006 10:45 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite3_interrupt() and threads
Hi Richar
Hi Richard,
I use a progres_handler:
http://www.sqlite.org/capi3ref.html#sqlite3_progress_handler
I set it up to be called every 1 ticks (2nd argument) or so and
I use and the void* to points to a data structure that contains a
boolean isCanceled. If another thread wants to cancel the worke
Thank you for pointing me to that article. That leads to two more
questions:
What alternative do I have? If I abort the thread that is running the
query, will the query stop?
And, if sqlite3_interrupt() has to be issued from the same thread that
is using the database, what is it designed to b
I have a multi-threaded application. Each thread has its own database
connection. One of the thread changes the schema of the database (DROP
TABLE, CREATE TABLE). I have observed that the other threads do not know
about these modifications since queries for the new/altered table doesn't
return the
Hello Andrew!
I got a little into OLAP functions this morning and I'm really surprised by
it! A great tool to define complex business logic in a db! (And perhaps more
than just that...)
It fits perfectly to my problem. Now I have to learn how to define an own
appropriate olap function for my db.
Rob Richardson wrote:
[...] Can sqlite3_interrupt() be called from a different
thread than the sqlite3_step() that I want to interrupt, or is there
some other mechanism I can use, or is there no way to do this?
This came up a couple of weeks ago. I don't have the message here to
quote but you
Greetings!
My application will occasionally be called on to execute queries that
take several minutes. This will be done from a worker thread so that
the user interface remains active. As the query is being executed, the
user must be able to respond to alarms. When the user hits F11 to go
strai
On Jul 24, 2006, at 11:47, Xavier Noria wrote:
I am trying to understand a crash I get very often. There are two
processes accessing to the same database in a Windows XP (through
Active Record) doing simple CRUDs on tables, and from any of the
two at random I get an SQLite3::BusyException,
Hi Martin, Jens and Clark, thank you all for your comments and suggestions,
they all work perfectly.
What I actually meant to ask was how would I delete a field(column) when the
name of that column wasnt known using the create temp function, but I worded
my orignial question wrong. But from all
"Jonathan Ellis" <[EMAIL PROTECTED]> wrote:
> Thanks, that is a good workaround.
>
> Is this a bug or a "feature?"
>
Probably a bug. But a low-priority one.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Thanks for your reply Peter.
After your reply i had a closer look at this and i
noticed that the "files" in the commandline aren't
only missing the prefix "lib", but also the suffix (?)
".dll.a". so when i added sqlib3 to the list it worked
fine.
this had never come to my mind, thanks for this real
On 7/25/06, Fred Williams <[EMAIL PROTECTED]> wrote:
Good Grief! Everybody knows CRUD is what you clean off on US Navy ships
at least once a week.
Nice to know it only affects US Navy ships ;-)
(couldn't resist)
In the ld command line, don't use the "lib" prefix, specify
"sqlite3.dll.a" instead of "libsqlite3.dll.a".
Peter
On 7/25/06, Hat Keinen <[EMAIL PROTECTED]> wrote:
Hello,
I'm using the MinGW Developer Studio (on
windows/windows version), http://www.parinyasoft.com/
Currently I'm trying to get i
Hello,
I'm using the MinGW Developer Studio (on
windows/windows version), http://www.parinyasoft.com/
Currently I'm trying to get it to work with the SQLite
lib.
for testing/first steps i'm using the precompiled
files from http://rainforce.org/sqlite/
I successfully "installed" the header files,
33 matches
Mail list logo
