Re: [sqlite] Reason for random names for the master journal?

2011-02-25 Thread Dan Kennedy
>> For example, say you have two databases in a transaction - mine.db >> and yours.db. A crash happens while committing the transaction >> and the file mine.db-mjMASTER is left in the file-system. >> >> Following recovery, if a process tries to read mine.db, the >> transaction on mine.db will be

Re: [sqlite] Virtual Table and the xBestIndex

2011-02-25 Thread Jay A. Kreibich
On Fri, Feb 25, 2011 at 09:30:00PM -0500, Dariusz Matkowski scratched on the wall: > I am trying to implement a simple virtual table that reads in a file > with two columns and "::" separator. My question is: is it necessary > to implement xBestIndex to run a simple where clause queries? You

[sqlite] long insert statement failing on iPhone

2011-02-25 Thread Mickey Mestel
hi all, new to the list. we are compiling the sqlite.c amalgamation file into our project, as we want to encrypt the database, and the sqlite that comes with the iOS sdk does not allow for that. we are developing on iOS 4.2, and to date have tried 3 different versions

[sqlite] Virtual Table and the xBestIndex

2011-02-25 Thread Dariusz Matkowski
Hi all, I am trying to implement a simple virtual table that reads in a file with two columns and "::" separator. My question is: is it necessary to implement xBestIndex to run a simple where clause queries? Thank you. - This

Re: [sqlite] Reason for random names for the master journal?

2011-02-25 Thread Drake Wilson
Quoth Johns Daniel , on 2011-02-25 16:21:54 -0600: > Thank you very much for this info, Dan! Very useful. > > >From your description, it sounds like this requirement only applies if > there are 3 or more databases. Is this an issue with 2 databases? Yes, master journals

Re: [sqlite] Reason for random names for the master journal?

2011-02-25 Thread Johns Daniel
On Fri, Feb 25, 2011 at 12:04 PM, Dan Kennedy wrote: > On 02/26/2011 12:30 AM, Johns Daniel wrote: >> What is the reason was for having random filenames for the SQLite >> master journal file (like mine.db-mj501CA440, mine.db-mj1C17, >> mine.db-mj66677495, etc)? >> >>

[sqlite] BUG: types3.test

2011-02-25 Thread Noah Hart
this test in types3 says that the type is "" do_test types3-2.5 { set V [db one {SELECT '1234567890123456.0'}] tcl_variable_type V } {} however when I try it from the command line i get text SQLite version 3.7.5 Enter ".help" for instructions Enter SQL statements terminated with a ";"

Re: [sqlite] Reason for random names for the master journal?

2011-02-25 Thread Dan Kennedy
On 02/26/2011 12:30 AM, Johns Daniel wrote: > What is the reason was for having random filenames for the SQLite > master journal file (like mine.db-mj501CA440, mine.db-mj1C17, > mine.db-mj66677495, etc)? > > Here is the reason for this strange question. We have discovered that > the JFFS2

[sqlite] Reason for random names for the master journal?

2011-02-25 Thread Johns Daniel
What is the reason was for having random filenames for the SQLite master journal file (like mine.db-mj501CA440, mine.db-mj1C17, mine.db-mj66677495, etc)? Here is the reason for this strange question. We have discovered that the JFFS2 filesystem in Linux is leaking kernel memory each time we

[sqlite] Hugues Geymond/BR/PRS/BTMEU is out of the office this afternoon.

2011-02-25 Thread hugues . geymond
I will be out of the office starting 02/24/2011 and will not return until 02/28/2011. I will respond to your message when I return. If necessary please contact M. Fahloul * The information contained in this

Re: [sqlite] Parallel execution of queries in threads

2011-02-25 Thread Maddy
I had tried on sqlite version 3.7.4. Let me check it on sqlite version 3.7.5. Thanks, Madhav On Thu, Feb 24, 2011 at 9:19 PM, Richard Hipp wrote: > > > On Thu, Feb 24, 2011 at 4:52 AM, Maddy wrote: > >> Hi, >> I have 4 "SELECT" queries which are

Re: [sqlite] memory used by sqlite library

2011-02-25 Thread Michele Pradella
thank you for the advice, I found even this: http://www.sqlite.org/malloc.html#memstatus that describe the possibility to set the memory usage limit Il 25/02/2011 14.24, Marco Bambini ha scritto: > Michele take a look at the sqlite3_status function: > http://www.sqlite.org/c3ref/status.html > and

Re: [sqlite] memory used by sqlite library

2011-02-25 Thread Marco Bambini
Michele take a look at the sqlite3_status function: http://www.sqlite.org/c3ref/status.html and http://www.sqlite.org/c3ref/c_status_malloc_count.html -- Marco Bambini http://www.sqlabs.com On Feb 25, 2011, at 2:17 PM, Michele Pradella wrote: > Do you know if is there a way to ask to the

[sqlite] memory used by sqlite library

2011-02-25 Thread Michele Pradella
Do you know if is there a way to ask to the sqlite library the amount of memory that is using? It could be useful when I have to take a look to the memory used in my application. So I can distinguish between memory allocated by my application itself and allocated by sqlite library. It's

Re: [sqlite] COUNT() extremely slow first time!

2011-02-25 Thread Max Vlasov
On Fri, Feb 25, 2011 at 1:51 AM, Greg Barker wrote: > I ran my tests again, this time setting the cache_size based on the > page_size. For some reason I wasn't able to replicate the timing I got > before for the 1024 page size (40.2 seconds) which is really confusing me, >

Re: [sqlite] COUNT() extremely slow first time!

2011-02-25 Thread Simon Slavin
On 24 Feb 2011, at 10:51pm, Greg Barker wrote: > What do > you do if there could be anywhere between 30-150 columns? I would never have any table with 150 columns. It should be possible to keep the schema for your table in your head. > Optimizing performance > for an application where both

Re: [sqlite] COUNT() extremely slow first time!

2011-02-25 Thread Greg Barker
I ran my tests again, this time setting the cache_size based on the page_size. For some reason I wasn't able to replicate the timing I got before for the 1024 page size (40.2 seconds) which is really confusing me, since I was careful to make sure nothing was running in the background while I was

Re: [sqlite] COUNT() extremely slow first time!

2011-02-25 Thread Greg Barker
Average payload per entry for my test table was 409.00. Sounds about right since the db has 4 columns and each is filled with a random string of length 100. I've uploaded the full output from the sqlite3_analyzer for a few different page sizes: http://fletchowns.net/files/1024-analyzer.txt