Thanks, Igor.
On Monday, 30 December 2013, Igor Tandetnik wrote:
> On 12/30/2013 9:14 AM, narkewo...@gmail.com wrote:
>
>> If I don't call sqlite3_clear_binding but rebind every parameter with
>> sqlite3_bind_type before every sqite3_step after sqlite3_reset, will it
>> be any different?
>>
>
>
Hi,
I found sqlite (3.8.2 as well as 3.7.17) cannot stand reliably with some
simple insert/update operations on a single table with primary
key. I found this problem on ARM platform with varities of filesystems
including UBIFS, Yafss on NAND, and Ext4 on SDCARD.
Attached is the test program
eabi compiler. With the same complier and the toolchain, I
have been buit a whole target ARM system including kernel, 1000 open source
applications, even including a tiny X window.
On Tuesday, 31 December 2013, Simon Slavin wrote:
>
> On 31 Dec 2013, at 8:41am, Woody Wu <narkewo...@
Does anyone have a clue? BTW, happy new year :)
On Tuesday, 31 December 2013, Woody Wu wrote:
> Hi, Simon
>
> I upload the source code onto my dropbox:
> https://www.dropbox.com/s/9shhshi0wn3e717/downloadfile.c Please have a
> look at it.
>
> The same test program run wi
Kaminskiy wrote:
> Woody Wu wrote:
> > Hi, Simon
> >
> > I upload the source code onto my dropbox:
> > https://www.dropbox.com/s/9shhshi0wn3e717/downloadfile.c Please have a
> > look at it.
> >
> > The same test program run without a problem on my pc Li
Hi,
The manual says that it should to rollback after sqlite3_step() returns
SQLITE_BUSY as long as
the current statment is in a transaction. Is this true? Why I cannot just
sleep for a while
and redo the sqlite3_step()?
Thanks in advance.
--
Life is the only flaw in an otherwise perfect
Thanks for the clear guide. _busy_timeout is easier to use. By the way, i
want confirm that if i am not in an explicit transaction, i can simply redo
the _step() invoking, right?
On Tuesday, 7 January 2014, Simon Slavin wrote:
>
> On 7 Jan 2014, at 8:50am, Woody Wu <narkewo...@
was trying to update
still locked by another process. This is normal, right?
On 7 January 2014 19:32, Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 7 Jan 2014, at 10:13am, Woody Wu <narkewo...@gmail.com> wrote:
>
> > Thanks for the clear guide. _busy_timeout is eas
Hi,
I want to omits the Sqlite's internal invocation of malloc(3). What I
tried were following,
1. Provide sqlite compile time options "-DSQLITE_ZERO_MALLOC
-DSQLITE_ENABLE_MEMSYS5"
2. In the startup code of my application, call:
sqlite3_config(SQLITE_CONFIG_HEAP, my_static_array, ...)
Do you
Hi, List
I found my sqlite application presents a huge VSZ usage, 100+M in an
ARM system, which has only 128M physical memory. Does this because
sqlite is using mmap to map the database file? If this is the reason,
how can I reduce the VSZ used?
I checked my application with Valgrind, I think
On 19 February 2014 23:09, Clemens Ladisch <clem...@ladisch.de> wrote:
> Woody Wu wrote:
>> I found my sqlite application presents a huge VSZ usage, 100+M in an
>> ARM system, which has only 128M physical memory. Does this because
>> sqlite is using mm
On 20 February 2014 04:35, Clemens Ladisch <clem...@ladisch.de> wrote:
> Woody Wu wrote:
>> On 19 February 2014 23:09, Clemens Ladisch <clem...@ladisch.de> wrote:
>>> Woody Wu wrote:
>>>> sqlite is using mmap to map the database file?
>>
>>
qlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-Woody Wu
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
than 1 second on the same system.
Also, I tried to replace the very large time value to a small enough one,
3. select max(time) from mytable where time < 0 and id1=k1 and id2=n
This query also run very fast.
Could anyone explain this to me? Thanks in advance.
On 2014年5月7日 GMT+08:00AM3:16:35, Clemens Ladisch <clem...@ladisch.de> wrote:
>Woody Wu wrote:
>> The following query statement executed very slow, it took 15 secs on
>my ARM device,
>>
>> 1. select max(time) from mytable where time < and id1 = k1
>and
On 2014年5月8日 GMT+08:00AM1:51:43, Clemens Ladisch <clem...@ladisch.de> wrote:
>Simon Slavin wrote:
>> On 7 May 2014, at 1:29pm, Woody Wu <narkewo...@gmail.com> wrote:
>>> The 'explain query plan' gives same result for the first and the
>second query:
>>>
&g
On 2014年5月8日 GMT+08:00PM9:14:52, Clemens Ladisch <clem...@ladisch.de> wrote:
>Woody Wu wrote:
>> On 2014年5月8日 GMT+08:00AM1:51:43, Clemens Ladisch <clem...@ladisch.de>
>wrote:
>>> Simon Slavin wrote:
>>>> You can let SQLite make a better estimate by
On 2014年5月8日 GMT+08:00PM11:59:33, RSmith <rsm...@rsweb.co.za> wrote:
>
>On 2014/05/08 14:13, Woody Wu wrote:
>>
>> Do you mean that my index for this case is already the best choice?
>>
>> And, as a general question, for a query in the form of
>>sele
On 2014年5月8日 GMT+08:00PM11:59:33, RSmith <rsm...@rsweb.co.za> wrote:
>
>On 2014/05/08 14:13, Woody Wu wrote:
>>
>> Do you mean that my index for this case is already the best choice?
>>
>> And, as a general question, for a query in the form of
>>sele
On Friday, 9 May 2014, RSmith <rsm...@rsweb.co.za> wrote:
>
> On 2014/05/08 18:16, Woody Wu wrote:
>
>> On 2014年5月8日 GMT+08:00PM11:59:33, RSmith <rsm...@rsweb.co.za> wrote:
>>
>>> On 2014/05/08 14:13, Woody Wu wrote:
>>>
>>>> Do
Hi, List
Probably this is another case of database corrupted. I read the
documents about this topic and think I did not make same mistakes
described in that 'how to corrupt ...' documentation.
I have a testing code, attached in this email, if continuously run it for
20 - 40 hours, the sqlite
On Mon, May 27, 2013 at 11:08:57AM +0800, Woody Wu wrote:
> Hi, List
>
> Probably this is another case of database corrupted. I read the
> documents about this topic and think I did not make same mistakes
> described in that 'how to corrupt ...' documentation.
>
> I have a t
vin <slav...@bigfraud.org>
> wrote:
>
> >
> > On 27 May 2013, at 1:25pm, Clemens Ladisch <clem...@ladisch.de> wrote:
> >
> > > Woody Wu wrote:
> > >> I have a testing code, attached in this email, if continuously run it
> > for
> > >>
On Mon, May 27, 2013 at 04:31:25PM +0100, Simon Slavin wrote:
>
> On 27 May 2013, at 4:22pm, Woody Wu <narkewo...@gmail.com> wrote:
>
> > If Yaffs2 is the cause, how can I write an effective test to exposure it?
>
> Do you have an opportunity to format the same dr
On Mon, May 27, 2013 at 11:33:08AM -0400, Richard Hipp wrote:
> On Mon, May 27, 2013 at 11:22 AM, Woody Wu <narkewo...@gmail.com> wrote:
>
> > Richard,
> >
> > If Yaffs2 is the cause, how can I write an effective test to exposure it?
> >
>
> Do you re
nderstand what's the right
responsibilities of a fs or device driver.
>
> On Mon, May 27, 2013 at 10:22 AM, Woody Wu <narkewo...@gmail.com> wrote:
>
> > Richard,
> >
> > If Yaffs2 is the cause, how can I write an effective test to exposure it?
> > I strace
On Mon, May 27, 2013 at 04:31:25PM +0100, Simon Slavin wrote:
>
> On 27 May 2013, at 4:22pm, Woody Wu <narkewo...@gmail.com> wrote:
>
> > If Yaffs2 is the cause, how can I write an effective test to exposure it?
>
> Do you have an opportunity to format the same
On Tue, May 28, 2013 at 03:08:55AM +0100, Simon Slavin wrote:
>
> On 28 May 2013, at 2:37am, Woody Wu <narkewo...@gmail.com> wrote:
>
> > How do you guys think about this: if NAND has an
> > IO problem, Yaffs2 should recover it or forward the error to
> > a
system was built by our external vendor, I don't know their process.
Can I check if it's correctly done? Erasing Yaffs2 means something like
'mke2fs'
on a ext* file system? Thanks.
>
>
> On Mon, May 27, 2013 at 11:44 PM, Woody Wu <narkewo...@gmail.com> wrote:
>
> >
Hi,
I have serveral questions about exclusive transaction. (version 3.7.x)
1. When a exclusive transation started and not yet commit, I found if I
open another connection to the same database and try to access it (using
sqlite3_step), I got the error code SQLITE_MISUSE. It sounds a little
I have an old dabase, some integer columns were defined as type of
number(2). What does this mean in sqlite3? What's the data ragne it
can represent, and how much bytes it will consume when stored?
Thanks in advance.
--
I can't go back to yesterday - because I was a different person then
On Wed, Jul 10, 2013 at 09:53:41AM +0200, Paolo Bolzoni wrote:
> See here:
> http://www.sqlite.org/datatype3.html
>
> I think it just means Integer. And its
> size depends on the magnitude of the
> number stored.
>
I've read the doc, it's not so easy to understand.
Did you mean, in number(N),
. It's just a database created many years ago, probabaly
sqlite supported that then. Thanks for your explaination.
> On Wed, Jul 10, 2013 at 10:06 AM, Woody Wu <narkewo...@gmail.com> wrote:
> > On Wed, Jul 10, 2013 at 09:53:41AM +0200, Paolo Bolzoni wrote:
> >> See here:
>
33 matches
Mail list logo