Re: [sqlite] Slow sqlite3_open() - possible culprits?

2013-03-14 Thread Stephen Chrzanowski
If you're attempting to open a read only SQLite database, it seems as though it will take that time to validate write permissions. I don't know what CEROD is. In that thread, to which I was a part of, you'll notice that when I changed just the basic file attribute to read only, even the CLI

Re: [sqlite] Slow sqlite3_open() - possible culprits?

2013-03-14 Thread Mohit Sindhwani
Hi Stephen, Thanks for the reply! On 14/3/2013 2:20 PM, Stephen Chrzanowski wrote: If you're attempting to open a read only SQLite database, it seems as though it will take that time to validate write permissions. By "read only", I meant that the database is for reading only. It doesn't

Re: [sqlite] TCL Test failures on ARM

2013-03-14 Thread bkk
Appreciate if someone can point out what’s going wrong with these tests -- View this message in context: http://sqlite.1065341.n5.nabble.com/TCL-Test-failures-on-ARM-tp67612p67707.html Sent from the SQLite mailing list archive at Nabble.com. ___

Re: [sqlite] TCL Test failures on ARM

2013-03-14 Thread Dan Kennedy
On 03/13/2013 01:03 PM, bkk wrote: Hi, Below is the code sequence after making a breakpoint at robust_ftruncate() i could see that "robust_ftruncate" and "ts_ftruncate" is called couple of times before the error is given to the user Breakpoint 2, ts_ftruncate (fd=5, n=297136) at

Re: [sqlite] TCL Test failures on ARM

2013-03-14 Thread bkk
Does it have anything to do with platform ? i am not sure though , because i am new to ARM and sqlite. Thanks Brijesh -- View this message in context: http://sqlite.1065341.n5.nabble.com/TCL-Test-failures-on-ARM-tp67612p67709.html Sent from the SQLite mailing list archive at Nabble.com.

[sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Vitor Rosa
Hello, I'm using windows 7 (64 bits) with sqlite 3.7.15.2 and I can't change journal_mode to WAL, it always return memory mode. what I can do? Many thanks, Vitor. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] set journal off working witth SQLiteConfig?

2013-03-14 Thread Doug Crites
Hello, I am using the sqlite-jdbc-3.7.8-20111025.014814-1.jar , trying to set the journaling off on my 'main' only opened db. SQLiteConfig config = new SQLiteConfig(); config.setJournalMode(SQLiteConfig.JournalMode.OFF); writeLog("Timestamp properties");

Re: [sqlite] Slow sqlite3_open() - possible culprits?

2013-03-14 Thread Richard Hipp
On Thu, Mar 14, 2013 at 12:34 AM, Mohit Sindhwani wrote: > Hi, we are using SQLite3 + CEROD for a number of databases in an embedded > systems application running on Windows CE. We're finding unexpectedly long > time to open the database (0.5s ~ 2.8sec). Maybe, these times are

Re: [sqlite] SQLite 3.7.16 beta

2013-03-14 Thread Richard Hipp
The draft website for SQLite version 3.7.16 can be seen on the http://www.sqlite.org/draft/ page and its descendents. The status board for 3.7.16 (http://www.sqlite.org/checklists/3071600) is now all green, meaning that all test cases have passed. We are simply waiting to give beta testers a few

Re: [sqlite] set journal off working witth SQLiteConfig?

2013-03-14 Thread Richard Hipp
On Wed, Mar 13, 2013 at 1:29 PM, Doug Crites wrote: > > Hello, > > I am using the sqlite-jdbc-3.7.8-20111025.014814-1.jar , trying to set the > journaling off on my 'main' only opened db. > > SQLiteConfig config = new SQLiteConfig(); >

Re: [sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Richard Hipp
On Wed, Mar 13, 2013 at 12:45 PM, Vitor Rosa wrote: > Hello, > > I'm using windows 7 (64 bits) with sqlite 3.7.15.2 and I can't change > journal_mode to WAL, it always return memory mode. > what I can do? > For an in-memory database, the only allowed journal modes are

Re: [sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Vitor Rosa
Hello, After reading more carefully the documentation I found that, but I want to create a db where I'm having just one writer and multiple readers, but I need that the readers never get "db locked" when they are reading so I thought using WAL journal_mode. But how can I create a WAL db? Many

Re: [sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Richard Hipp
On Thu, Mar 14, 2013 at 9:40 AM, Vitor Rosa wrote: > Hello, > > After reading more carefully the documentation I found that, but I want to > create a db where I'm having just one writer and multiple readers, but I > need that the readers never get "db locked" when they

[sqlite] Query optimizer suboptimal planning with virtual tables

2013-03-14 Thread Eleytherios Stamatogiannakis
Hi, I have came across a glitch with how SQLite's query optimizer plans virtual tables. Example follows: I have a virtual table function named "range" that produces all numbers from 1 to range's arg. This virtual table does not have any index functionality. With this i'll create the

Re: [sqlite] Query optimizer suboptimal planning with virtual tables

2013-03-14 Thread Clemens Ladisch
Eleytherios Stamatogiannakis wrote: >> explain query plan select * from t1, t2 where t1.c1=t2.c1; > 0 |0 |1 | SCAN TABLE t2 (~100 rows) > 0 |1 |0 | SCAN TABLE t1 VIRTUAL TABLE INDEX 0: (~0 rows) > > Even thought, i have put VT t1 first in the join list, SQLite > will do a nested loop join

Re: [sqlite] Query optimizer suboptimal planning with virtual tables

2013-03-14 Thread Eleytherios Stamatogiannakis
On 14/03/13 17:05, Clemens Ladisch wrote: Eleytherios Stamatogiannakis wrote: explain query plan select * from t1, t2 where t1.c1=t2.c1; 0 |0 |1 | SCAN TABLE t2 (~100 rows) 0 |1 |0 | SCAN TABLE t1 VIRTUAL TABLE INDEX 0: (~0 rows) Even thought, i have put VT t1 first in the join list,

[sqlite] Query optimizer bug?

2013-03-14 Thread Ryan Johnson
Hi all, I'm running sqlite-3.7.13 on cygwin. Playing around with various TPC-H queries with my class recently, I hit a strangely slow query and don't understand why it's so slow. The schema and dataset generator are available at tpc.org, and end of this message has instructions to replicate

[sqlite] Announcing Zumero (commercial venture, built on SQLite)

2013-03-14 Thread Eric Sink
I'll keep this short and low-key: Zumero is a sync solution for SQLite, designed for mobile devices. http://zumero.com/ Here's my blog post on it: http://ericsink.com/entries/announcing_zumero.html -- E ___ sqlite-users mailing list

Re: [sqlite] Query optimizer bug?

2013-03-14 Thread Richard Hipp
Nitpick: A "bug" means it gets the wrong answer, which is not the case here. What you are reporting here is not a bug but an optimization opportunity. On Thu, Mar 14, 2013 at 2:07 PM, Ryan Johnson wrote: > The offending query (slightly modified version of Q7: > >

Re: [sqlite] Query optimizer suboptimal planning with virtual tables

2013-03-14 Thread Clemens Ladisch
Eleytherios Stamatogiannakis wrote: > On 14/03/13 17:05, Clemens Ladisch wrote: >> Eleytherios Stamatogiannakis wrote: explain query plan select * from t1, t2 where t1.c1=t2.c1; >>> 0 |0 |1 | SCAN TABLE t2 (~100 rows) >>> 0 |1 |0 | SCAN TABLE t1 VIRTUAL TABLE INDEX 0: (~0 rows) >>> >>>

Re: [sqlite] Query optimizer bug?

2013-03-14 Thread Ryan Johnson
On 14/03/2013 3:09 PM, Richard Hipp wrote: Nitpick: A "bug" means it gets the wrong answer, which is not the case here. What you are reporting here is not a bug but an optimization opportunity. Oops... you're right. Sorry about that. On Thu, Mar 14, 2013 at 2:07 PM, Ryan Johnson

Re: [sqlite] TCL Test failures on ARM

2013-03-14 Thread Bk
Hi, can any one tel me how can i fix this issue ? Thank you Brijesh -- View this message in context: http://sqlite.1065341.n5.nabble.com/TCL-Test-failures-on-ARM-tp67612p67727.html Sent from the SQLite mailing list archive at Nabble.com. ___