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