[sqlite] sqlite_busy in multithreaded application

2005-07-21 Thread Neelamegam Appadurai
Hi, Though they were lot of discussion on this, I could not find solution in my case. To elaborate the happening. Let me say i have two threads 1.ReadThread 2. DeleteThread My ReadThread does the following. 1. Compile and Create SQLStatement 2. Generate QueryObject 3. Query and finalize . 4. Re

Re: [sqlite] optimizing database creation speed

2005-07-21 Thread Al Danial
On 7/21/05, Chuck Pahlmeyer - MTI <[EMAIL PROTECTED]> wrote: > I have an application in which I'd like to create a database as > quickly as possible. The application has a batch process at > startup which creates the data. I am using a single transaction > for all of the INSERT statements. I'm also

Re: [sqlite] optimizing database creation speed

2005-07-21 Thread Joseph Bruni
Have you tried postgresql? I haven't run any time tests myself, yet. http://www.postgresql.org You might also want to look away from SQL databases entirely and use an unstructured database such as BerkeleyDB. Sometimes you don't need the overhead of structure. http://www.sleepycat.com Af

[sqlite] optimizing database creation speed

2005-07-21 Thread Chuck Pahlmeyer - MTI
I have an application in which I'd like to create a database as quickly as possible. The application has a batch process at startup which creates the data. I am using a single transaction for all of the INSERT statements. I'm also using prepared statements to alleviate some of the overhead for pro

Re: [sqlite] CURRENT_TIME returns false value

2005-07-21 Thread D. Richard Hipp
On Thu, 2005-07-21 at 22:32 +0200, Cyril Scetbon wrote: > Hi, > > I don't understand why when I use select CURRENT_TIME from sqlite I get > a false value as follows : > > [EMAIL PROTECTED]:~$ date > Thu Jul 21 22:37:20 CEST 2005 > [EMAIL PROTECTED]:~$ sqlite3 /tmp/test.db "select CURRENT_TIME" >

Re: [sqlite] CURRENT_TIME returns false value

2005-07-21 Thread Joseph Bruni
whalesong:~ brunij$ date Thu Jul 21 13:40:42 MST 2005 whalesong:~ brunij$ sqlite3 /dev/null 'select current_time' 20:40:44 It works for me. I'm located at GMT-7. Where are you? Perhaps what you wanted was: select datetime('now','localtime'); On Jul 21, 2005, at 1:32 PM, Cyril Scetbon wrot

Re: [sqlite] CURRENT_TIME returns false value

2005-07-21 Thread Puneet Kishor
Cyril Scetbon wrote: Hi, I don't understand why when I use select CURRENT_TIME from sqlite I get a false value as follows : [EMAIL PROTECTED]:~$ date Thu Jul 21 22:37:20 CEST 2005 [EMAIL PROTECTED]:~$ sqlite3 /tmp/test.db "select CURRENT_TIME" 20:37:26 because it is returning UTC (Coordina

[sqlite] CURRENT_TIME returns false value

2005-07-21 Thread Cyril Scetbon
Hi, I don't understand why when I use select CURRENT_TIME from sqlite I get a false value as follows : [EMAIL PROTECTED]:~$ date Thu Jul 21 22:37:20 CEST 2005 [EMAIL PROTECTED]:~$ sqlite3 /tmp/test.db "select CURRENT_TIME" 20:37:26 thanks

Re: [sqlite] Efficient record insertion techniques?

2005-07-21 Thread Christian Smith
On Wed, 20 Jul 2005, Puneet Kishor wrote: > >I have never quite understood these LIMIT commands... how they would >LIMIT without running the entire query anyway. If you want to >constrain, the constrain should really be in the WHERE clause. > They are for reducing the result set size, very helpf

Re: [sqlite] Writing Triggers in C/C++

2005-07-21 Thread Edwin Knoppert
That would be cool, using a callback! :) - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 20, 2005 11:07 PM Subject: Re: [sqlite] Writing Triggers in C/C++ if you write a user defined function and call that from a trigger you could. On 7/20/0