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

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. > W

Re: [sqlite] mutex and begin/end transaction

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, a

[sqlite] sqlite3_mutex_enter(db->mutex) problem

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

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 id

Re: [sqlite] mutex and begin/end transaction

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

Re: [sqlite] mutex and begin/end transaction

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

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 in

Re: [sqlite] mutex and begin/end transaction

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, fe

[sqlite] sqlite performance tuning and optimization

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, EventRef,ToState,Prior

Re: [sqlite] mutex and begin/end transaction

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 dang

Re: [sqlite] mutex and begin/end transaction

-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 operati

Re: [sqlite] Transaction control At the SQL Level

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 At the SQL Level Joa

Re: [sqlite] Transaction control At the SQL Level

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 first database statement >

Re: [sqlite] Transaction control At the SQL Level

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 s

Re: [sqlite] in memory database and jdbc

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 to do so, I setup a Connec

Re: [sqlite] mutex and begin/end transaction

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

Re: [sqlite] mutex and begin/end transaction

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 b

[sqlite] in memory database and jdbc

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 datab

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

"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 reason. >> It's true that the speed of inserting wi

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

"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 reason. >> It's true that the speed of inserting with

Re: [sqlite] ResultSetMetaData with javasqlite

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 ht

[sqlite] Database disk image is malformed

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 aft