[sqlite] Auto Reply: Re: unexpected large journal file

2010-06-19 Thread dave . segleau
I am out of the office from June 13th through the July 4th. I will be back in the office on July 5th. I will only have intermittent access to email and my cell phone during that time. I will read and reply to your message when I get back to the office. If you need assistance with a Berkeley

[sqlite] Auto Reply: Bug in shell.c

2010-06-19 Thread dave . segleau
I am out of the office from June 13th through the July 4th. I will be back in the office on July 5th. I will only have intermittent access to email and my cell phone during that time. I will read and reply to your message when I get back to the office. If you need assistance with a Berkeley

[sqlite] where to find an examples of writing a extension?

2010-06-19 Thread Sam Carleton
I need to add a new where clause to my query, one that checks to see if the file actually exits. I am thinking the correct solution is a user defined function, something like: bool DoesFilesReallyExist(char* rootPath, char* relativePath, char* filename) Where I could do a query like this:

[sqlite] Auto Reply: Auto Reply: Locked Database Problem

2010-06-19 Thread dave . segleau
I am out of the office from June 13th through the July 4th. I will be back in the office on July 5th. I will only have intermittent access to email and my cell phone during that time. I will read and reply to your message when I get back to the office. If you need assistance with a Berkeley

[sqlite] Auto Reply: Locked Database Problem

2010-06-19 Thread dave . segleau
I am out of the office from June 13th through the July 4th. I will be back in the office on July 5th. I will only have intermittent access to email and my cell phone during that time. I will read and reply to your message when I get back to the office. If you need assistance with a Berkeley

Re: [sqlite] unexpected large journal file

2010-06-19 Thread Gerry Snyder
On 6/18/2010 7:01 PM, Scott Hess wrote: > > The old-school solution to this problem is an external sort (*). The > basic idea is that you process the incoming data in memory-sized > chunks (ie, fast), then write out sorted subfiles. Then you process > the sorted files in parallel, merging to the

Re: [sqlite] unexpected large journal file

2010-06-19 Thread Eric Smith
Jay A. Kreibich wrote: > Try getting rid of the PK definition and see how much that buys you. > It might be worth it, or it might not. and Simon Slavin wrote: > We know you are doing a huge amount of writing to this database. Are > you also reading it frequently ? If not, then it

Re: [sqlite] unexpected large journal file

2010-06-19 Thread Simon Slavin
On 19 Jun 2010, at 1:24am, Eric Smith wrote: > It's not in any way a result of my schema? My primary key is a pair of > integers A,B. The first column in this particular use case is in the > range A = [0, 2million) and the second is in the range B = [0, infinity). > We > > insert records

[sqlite] Locked Database Problem

2010-06-19 Thread Martin Sigwald
Hi, I'm running two different processes, both access the same database at given times, without synchronization. In order to handle a simultaneous access, I was testing for the BUSY condition. However, one of the processes is receiving a LOCKED status form SQLITE, resulting in a eternal deadlock.

[sqlite] Bug in shell.c

2010-06-19 Thread Brain, Stephen (UK)
Using version 3.6.23.1 amalgamation When processing an sql commands from a script file, if exactly two errors occur, then the shell exits. To replicate: Example file called test.sql End transaction; End transaction; Open the shell with no database and run: