Thank you Steven and Igor. Both methods worked.
Rene
-- Forwarded message --
From: steven.far...@dds.net
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Wed, 29 Apr 2009 11:56:15 -0400
Subject: Re: [sqlite] Another Date Question
If you just convert that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
James Gregurich wrote:
Given the industry is going multicore and 16-core macintoshes for your
grand-mother are just a few years away, I recommend you rethink your
position on the use of threading.
Threading is the worst solution to many
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
ddevienne wrote:
How does one get this list?
There is no public API. If you use the amalgamation then you can add
code to dig it out of the SQLite internals (a hash table amongst other
things). Look for functionSearch and sqlite3FindFunction
Or
Hi,
I have an application running on Windows CE4.1 PDAs with SD cards.
Sometimes I have errors executing commands on database that are:
11-database disk image is malformed
This happens for example on table MSTBP executing Delete From MSTBP.
Or inserting into it.
The strange thing is, that
Justin Deoliveira wrote:
Hi Justin,
Thanks for the quick response. I am not sure if this will be of any help
or not but I wrote this (very crude) patch to get around the problem:
http://files.opengeo.org/sqlite_jni.c.patch
...
Based on your patch there's now a improved version in
Matthew L. Creech mlcreech-re5jqeeqqe8avxtiumw...@public.gmane.org wrote
in message
news:5ee96a840904271946o315df05dxb45024d5c0474...@mail.gmail.com...
On Mon, Apr 27, 2009 at 10:25 PM, liubin liu
7101227-k+ct0dcb...@public.gmane.org wrote:
thanks
I'm not sure of the real reason.
It's true
Matthew L. Creech mlcreech-re5jqeeqqe8avxtiumw...@public.gmane.org wrote
in message
news:5ee96a840904271946o315df05dxb45024d5c0474...@mail.gmail.com...
On Mon, Apr 27, 2009 at 10:25 PM, liubin liu
7101227-k+ct0dcb...@public.gmane.org wrote:
thanks
I'm not sure of the real reason.
It's
Hi,
my java application uses a 80Mb reference database (read-only) that needs to be
consulted app. 4M times during a batch run. I would like to use the in-memory
capabilities of sqlite3 to improve the performance of my app.
In order to do so, I setup a Connection to the -in-memory- sqlite
A position is politics, not science. Warnings about the use of
threads are based on science, and advise you to avoid them if possible
for your own protection.
I see ill conceived programs using threads which go to complex
synchronization to achieve the equivalent of single stream execution
I'm curious: with all these warnings based on science how would you
implement application similar to apache web-server (forget about cgis
- just plain HTML) or something like database server? I understand
that you always can write something like cgi application which run on
every web-page hit but
2009/4/29 Tom van Ees tvan...@davincigroep.nl:
Hi,
my java application uses a 80Mb reference database (read-only) that needs to
be consulted app. 4M times during a batch run. I would like to use the
in-memory capabilities of sqlite3 to improve the performance of my app.
In order to do so,
Thanks a lot Igor respond my email.
Just want to make sure that I am fully understand about the single database
connection with multiple database statement handle here.
For example I have one database connection and 2 database statement handle
using the same connection. Using the first database
Joanne Pham joannekp...@yahoo.com wrote:
Just want to make sure that I am fully understand about the single
database connection with multiple database statement handle here.
For example I have one database connection and 2 database statement
handle using the same connection. Using the first
Again thanks Igor for detail information about autocommit for the sqlite
database connection.
Thanks,
JP
From: Igor Tandetnik itandet...@mvps.org
To: sqlite-users@sqlite.org
Sent: Thursday, April 30, 2009 10:24:16 AM
Subject: Re: [sqlite] Transaction control
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pavel Ivanov wrote:
I'm curious: with all these warnings based on science how would you
implement application similar to apache web-server
The danger with threading is in concurrent access to data. Apache has
several different modes of operation
So you don't even try to argue about database-servers-like
applications? Apache maybe indeed not very good example because of
good degree of independence between threads, though I think in some
cases caching across different connections and thus across different
threads could be useful.
The
I am using SQLIte3 database and my query is running slow
sometimes,sometimes it runs fast. Is there any sqlite Profiler available
just like SQL Profiler for SQL server?
My query looks like
SELECT ID, EventClassName, EventClassRef, TransitionTime, Message,
MonitoredRef,
With all due respect, science itself is a set of
positions (opinions) which are endorsed by small group of people as
official doctrine after appropriate study. Saying A 'position' is
politics, not science is not a particularly meaningful statement. If
you want to argue that point, feel
So, you suggest I should build a commercial desktop application (for
processing print-industry files and presenting them in a UI) in such
a way that it spawns multiple processes and communicates with them via
the filesystem or IPC APIs?
Why would I want to go to that level of complexity
Pavel Ivanov wrote:
I understand that. That's why concurrent access should be made very
wisely. But if this concurrent access is to some cache which allows to
avoid huge amount of disk reads - it's worth the effort.
The operating system also just happens to have a cache that allows
avoiding
James Gregurich wrote:
So, you suggest I should build a commercial desktop application (for
processing print-industry files and presenting them in a UI) in such
a way that it spawns multiple processes and communicates with them via
the filesystem or IPC APIs?
You obviously know more
I can't agree that such a thing would be a good approach in a
commercial desktop application environment. I'd never deploy something
like that to millions of graphic designers. I want everything in a
nice, tidy black-box that the average joe is incredibly unlikely to
screw up. I have no
Hi All,
I have the application and it is crashed on at ../src/vdbeapi.c:538
(sqlite3_mutex_enter(db-mutex); by sqlite3_step.
I couldn't nail down what was the root cause of this problem. Why it crashed on
sqlite3_mutex_enter API.
Would you please shed some light on this?
Thank in advance,
JP
James Gregurich wrote:
I want everything in a
nice, tidy black-box that the average joe is incredibly unlikely to
screw up.
Err, you don't have seventy five executables and expect the user to
manually launch and click them. It is indeed all hidden. They see one
window to one program, and
On May 1, 2009, at 7:58 AM, Joanne Pham wrote:
Hi All,
I have the application and it is crashed on at ../src/vdbeapi.c:538
(sqlite3_mutex_enter(db-mutex); by sqlite3_step.
I couldn't nail down what was the root cause of this problem. Why it
crashed on sqlite3_mutex_enter API.
Would
25 matches
Mail list logo