I realized that the amount of memory used for the page cache is different.
And I found that is the root cause.
Sorry for my careless mistake.
Thank you.
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
Yup, absolutely you are right.
I just ran a new test using the same upper bound on the amount of memory
used for the page cache, then I found a reasonable result.
Thank you, Dan.
I did notice the cache_size change before but you made me realize it.
Thanks a lot.
--
Sent from:
On 02/01/2018 04:05 PM, Nick wrote:
I update sqlite in my Android mobile phone from 3.9.2 to 3.16.2.
And I find the default page_size in 3.9.2 is 1024 while in 3.16.2 is 4096
(changed since 3.12.0).
I think SQLITE_DEFAULT_PAGE_SIZE has great effect on the performance so I
use speedtest1.c to
On 2/1/18, Nick wrote:
> I update sqlite in my Android mobile phone from 3.9.2 to 3.16.2.
>
> There are many test cases in speedtest1.c and case 270 is a DELETE case
> which is the most time-consuming one.
> There is a result. (different version + different
Um, I am a OS application developer and we just upgraded the source code on
our developing engine.
I am sure I used the same compile-options.
SQLITE_SECURE_DELETE is not set.
--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users
Nick wrote:
> I update sqlite in my Android mobile phone from 3.9.2 to 3.16.2.
How? Your own copy, or the system one?
Did you use the same configuration? Especially SQLITE_SECURE_DELETE?
Regards,
Clemens
___
sqlite-users mailing list
I update sqlite in my Android mobile phone from 3.9.2 to 3.16.2.
And I find the default page_size in 3.9.2 is 1024 while in 3.16.2 is 4096
(changed since 3.12.0).
I think SQLITE_DEFAULT_PAGE_SIZE has great effect on the performance so I
use speedtest1.c to test it.
There are many test cases in
7 matches
Mail list logo