Re: [sqlite] sqlite3_mutex_enter(db->mutex) problem

2009-04-30 Thread Dan
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. >

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread Roger Binns
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,

[sqlite] sqlite3_mutex_enter(db->mutex) problem

2009-04-30 Thread Joanne Pham
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

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread James Gregurich
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

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread Roger Binns
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

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread Roger Binns
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

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread James Gregurich
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

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread James Gregurich
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,

[sqlite] sqlite performance tuning and optimization

2009-04-30 Thread Kalyani Phadke
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,

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread Pavel Ivanov
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

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread Roger Binns
-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

Re: [sqlite] Transaction control At the SQL Level

2009-04-30 Thread Joanne Pham
Again thanks Igor for detail information about autocommit for the sqlite database connection. Thanks, JP From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Thursday, April 30, 2009 10:24:16 AM Subject: Re: [sqlite] Transaction control

Re: [sqlite] Transaction control At the SQL Level

2009-04-30 Thread Igor Tandetnik
Joanne Pham 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

Re: [sqlite] Transaction control At the SQL Level

2009-04-30 Thread Joanne Pham
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

Re: [sqlite] in memory database and jdbc

2009-04-30 Thread Simon Davies
2009/4/29 Tom van Ees : > 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

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread Pavel Ivanov
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

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread John Stanton
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

[sqlite] in memory database and jdbc

2009-04-30 Thread Tom van Ees
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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-30 Thread Giacomo Mussati
"Matthew L. Creech" 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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-30 Thread Skipper Informatica
"Matthew L. Creech" 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

Re: [sqlite] ResultSetMetaData with javasqlite

2009-04-30 Thread Christian Werner
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

[sqlite] Database disk image is malformed

2009-04-30 Thread Filipe Madureira
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

Re: [sqlite] listing registered SQL functions (aggregate or scalar)

2009-04-30 Thread Roger Binns
-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 >

Re: [sqlite] mutex and begin/end transaction

2009-04-30 Thread Roger Binns
-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

Re: [sqlite] Another Date Question

2009-04-30 Thread Rene Claassen
Thank you Steven and Igor. Both methods worked. Rene -- Forwarded message -- From: steven.far...@dds.net To: General Discussion of SQLite Database Date: Wed, 29 Apr 2009 11:56:15 -0400 Subject: Re: [sqlite] Another Date Question If you just convert that