Re: [sqlite] Question about multi-threading with a read-onlydatabase

2012-05-28 Thread Igor Tandetnik
Mohit Sindhwani wrote: > On 29/5/2012 10:52 AM, Igor Tandetnik wrote: >> That document is obsolete. It has been safe for a long time now. For >> details, see http://www.sqlite.org/threadsafe.html > > Thank you very much. However, reading this page also, it says: > >> Multi-thread. In this mode

Re: [sqlite] Question about multi-threading with a read-only database

2012-05-28 Thread Mohit Sindhwani
Hi Igor, On 29/5/2012 10:52 AM, Igor Tandetnik wrote: Mohit Sindhwani wrote: However, looking at this: http://www.sqlite.org/cvstrac/wiki?p=MultiThreading It has never been safe to use the same database connection simultaneously in multiple threads. That document is obsolete. It has been saf

Re: [sqlite] Question about multi-threading with a read-only database

2012-05-28 Thread Igor Tandetnik
Mohit Sindhwani wrote: > However, looking at this: > http://www.sqlite.org/cvstrac/wiki?p=MultiThreading > > It has never been safe to use the same database connection simultaneously in > multiple threads. That document is obsolete. It has been safe for a long time now. For details, see http://

[sqlite] Question about multi-threading with a read-only database

2012-05-28 Thread Mohit Sindhwani
Hi All, We have a read-only database (compiled with CEROD) that needs to be accessed from within the same program using multiple threads. Currently, we open the database once and all the threads use the sqlite3_db* to create their own personal prepared queries and run their queries. Howeve

Re: [sqlite] Update Query

2012-05-28 Thread Simon Slavin
On 29 May 2012, at 1:16am, IQuant wrote: > I may try a 2 pass approach: Pass 1 update query to record the rowid > of the previous symbol record and pass 2 use a join for performing the > IQ calcs. Yep. Just do it in your programming language. One SELECT to find the previous symbol records,

Re: [sqlite] Update Query

2012-05-28 Thread IQuant
Not sure how to combine the subqueries. Our TickData table looks close to: TimeStamp, Symbol, Ask, Bid, Last ... IQ_A, IQ_B, IQ_T, IQ_X We need to update the IQ fields with calculations always made between the current record and previous symbol record ordered by timestamp. I don't know how to

Re: [sqlite] FW: Problem with SQLite when deployed.

2012-05-28 Thread Richard
Peter, I'm not sure if this will help but I had exactly the same error but only on some Vista and XP installations. After much research I found that VC 2010 runtime support was missing from these PCs. If this is the same as your problem then you can either try one of the SQLite statically linked

Re: [sqlite] FW: Problem with SQLite when deployed.

2012-05-28 Thread Peter Walburn
On Friday, my when I ran the install routine and everything was installed on my 32-bit OS, it did not work properly. Then I manually copied the SQLite.Interop.dll over to the 32-bit OS, and it worked. However, when I included this file in the install program it did not work. Now I am unable t

Re: [sqlite] FW: Problem with SQLite when deployed.

2012-05-28 Thread Adam DeVita
Are you saying that you can manually place the dlls and exes on different computers and have it work? regards, Adam On Mon, May 28, 2012 at 7:36 AM, Peter Walburn wrote: > Okay, I've tried everything I can think of to get this to work. I've been > at it for 4 days now!! > > I know that it i

Re: [sqlite] FW: Problem with SQLite when deployed.

2012-05-28 Thread Peter Walburn
Okay, I've tried everything I can think of to get this to work. I've been at it for 4 days now!! I know that it is possible, because it did run on the 32-bit XP system that I was running my installation on - that's when I copied the 32-bit SQLite.Interop.dll from the 64-bit OS to the 32-bit OS

Re: [sqlite] FW: Problem with SQLite when deployed.

2012-05-28 Thread Peter Walburn
I thought that things were going to work ok on Friday, but now that my Install routine copies the 32-bit DLL files onto the 32-bit operating system, I am receiving the same errors. Installing the application (using the same install routine) on a 64-bit operating system does work fine. This mak