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
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
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.
___
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
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.
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
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");
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
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
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();
>
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
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
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
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
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
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,
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
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
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:
>
>
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)
>>>
>>>
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
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.
___
22 matches
Mail list logo