Re: [sqlite] Memory corruption in a mutilthreaded environment

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/08/12 18:42, Rittick Gupta wrote: > I have a program with multiple threads. You should run under valgrind/helgrind. > This may or may not anything to do with the problem I'd bet that your underlying problem is that some other part of your

[sqlite] Memory corruption in a mutilthreaded environment

I have a program with multiple threads. The threads do not share the same handle.Occcasionally the program dies with a core. I see a thread always with the following stack: #3 0x6000d336b7c0:0 in closeDB () at ../lang/sql/generated/sqlite3.c:35553 #4 0x6000d3388c60:0 in

Re: [sqlite] EXT :Re: Multi-Thread Reads to SQLite Database

On Fri, Aug 10, 2012 at 4:43 PM, Black, Michael (IS) wrote: > Why should shared cached be serialized when all the threads are reading? > I can see it for writing, but not just for reading. There must be some > logic that be done to allow this I would think (he said

Re: [sqlite] EXT :Re: Multi-Thread Reads to SQLite Database

On 8/10/2012 4:43 PM, Black, Michael (IS) wrote: Why should shared cached be serialized when all the threads are reading? I can see it for writing, but not just for reading. Reading involves bringing pages from disk into the cache, and possibly removing pages from the cache when full. So

Re: [sqlite] EXT :Re: Multi-Thread Reads to SQLite Database

Black, Michael wrote: Why should shared cached be serialized when all the threads are reading? I can see it for writing, but not just for reading. There must be some logic that be done to allow this I would think (he said without looking at the code). (from another non-student of the

Re: [sqlite] How to use SQLite on VxWorks5.5

Dear all, Hello, resently I have met some troubles when using SQLite on VxWorks5.5. Does anybody know how to transplant SQLite to VxWorks5.5, please help me, thank you very much. The VxWorks' vesion must be 5.5. Having used VxWorks in the past, I knew that threading and file

Re: [sqlite] EXT :Re: Multi-Thread Reads to SQLite Database

Why should shared cached be serialized when all the threads are reading? I can see it for writing, but not just for reading. There must be some logic that be done to allow this I would think (he said without looking at the code). Michael D. Black Senior Scientist Advanced Analytics

[sqlite] Documentation typo in "ON CONFLICT clause"

On page http://www3.sqlite.org/lang_conflict.html "the behavior proscribed the SQL standard" should be: "the behavior prescribed by the SQL standard" "pre" not "pro". ;-) Jesse Weinstein Software Engineer CliniComp, Intl. 9655 Towne Centre Drive San Diego, CA 92121 +1 [858]

Re: [sqlite] Multi-Thread Reads to SQLite Database

On Fri, Aug 10, 2012 at 12:18 PM, esum wrote: > > However, when I ran this same test with SQLITE_OPEN_READWRITE | > SQLITE_OPEN_SHAREDCACHE for the flags, I get the following [slower] > results: > > Why am I seeing such a high increase in times as I add threads in shared >

Re: [sqlite] Building System.Data.SQLite

Bernhard Mogens Ege wrote: > > I have been looking at > https://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki to build > System.Data.SQLite > uild%20System.Data.SQLite> but when using the manual build, I

[sqlite] Multi-Thread Reads to SQLite Database

Hi, I am developing a multi-threaded sqlite database application on an Ubuntu virtual machine that has 4 processors allocated to it. I am using sqlite version 3.7.13. I created a test to verify that multiple threads/connections can read from the database at the same time. I have two executables.

Re: [sqlite] SQLite Expert query execution speed

First, are both using the same version of the SQLite3 engine? Select sqlite_version(), sqlite_source_id(); Compiled with the same options? Pragma compile_options; Are they both using the same database file? How do the query plan's compare -- I would expect that they are significantly

[sqlite] How to use SQLite on VxWorks5.5

Dear all, Hello, resently I have met some troubles when using SQLite on VxWorks5.5. Does anybody know how to transplant SQLite to VxWorks5.5, please help me, thank you very much. The VxWorks' vesion must be 5.5. , -- Best Regards He Zhang

[sqlite] SQLite Expert query execution speed

hello, we have noticed that executing a select query in SQLite expert is 3 times as fast as executing it using our own C++ application. This seems quite odd as we are doing no funky stuff in the code, the sqlite3_step alone in our app takes longer then the entire process in (compiling the

[sqlite] Building System.Data.SQLite

I have been looking at https://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki to build System.Data.SQLite but when using the manual build, I do not get the setup files built..

Re: [sqlite] MATCH multiple

On 08/10/2012 12:48 PM, E. Timothy Uy wrote: I recently switched a table to FTS4. Usually I query this table using the IN operator, e.g., SELECT * FROM Table WHERE term IN (a,b,c) If I want to use MATCH, is my only option SELECT * FROM Table WHERE term MATCH 'a or b or c' I think