I know the reason why "PRAGMA mmap_size" could not improve the speed of
retrieving records from ZIPVFS DB.
However, I find sqlite3_soft_heap_limit64() , cache_szie and so on also which
could not help improve the speed.
Is all because of the ZIPVFS?
At 2015-12-23 12:34:33, "Richard Hipp"
Thank D. Richard Hipp very much.
I can understand what you said. That is very helpful for me.
Best regards
At 2015-12-23 12:34:33, "Richard Hipp" wrote:
>On 12/22/15, ??? <2004wqg2008 at 163.com> wrote:
>>What do you mean of "render the mmap_size mote "?
>
>The "PRAGMA mmap_size" comma
>Setting the mmap_size will normally help read performance a lot.
>However, if you are reading from a ZIPVFS database, the extra layer of
>decryption and decompression that sits in between the disk and your
>application will render the mmap_size mote - it won't matter.
Thanks very much. What yo
; At 2015-12-21 18:29:37, "Quan Yong Zhai" wrote:
>>> >pragma mmap_size= 51200;
>>> >Pragma page_size = 8192;
>>> >Vacuum;
>>> >Pragma cache_size = N;
>>> >
>>> >???: ???<m
take?
>
>> -Original Message-
>> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
>> bounces at mailinglists.sqlite.org] On Behalf Of ???
>> Sent: Tuesday, 22 December, 2015 19:49
>> To: SQLite mailing list
>> Subject: Re: [sql
" wrote:
>pragma mmap_size= 51200;
>Pragma page_size = 8192;
>Vacuum;
>Pragma cache_size = N;
>
>???: ???<mailto:2004wqg2008 at 163.com>
>: ?2015/?12/?21 18:08
>???: SQLite mailing list<mailto:sqlite-users at mailinglist
On 23 Dec 2015, at 4:46am, ??? <2004wqg2008 at 163.com> wrote:
> sqlite3_soft_heap_limit64() , cache_szie and so on also which could not help
> improve the speed
These commands reduce the amount of memory your application uses. They will
not help increase the speed unless you are repeatedly s
On 12/22/15, ??? <2004wqg2008 at 163.com> wrote:
>What do you mean of "render the mmap_size mote "?
The "PRAGMA mmap_size" command sets the operating-system interface
into a mode so that at calls mmap() to read content from disk rather
than calling read(). It is often faster to use mmap() bec
On 12/22/15, ??? <2004wqg2008 at 163.com> wrote:
>>> >pragma mmap_size= 51200;
>>> >Pragma page_size = 8192;
>>> >Vacuum;
>>> >Pragma cache_size = N;
> The above code has nothing to do with the speed of retrieving records,
> especially the beginning retrieve records from database.
> I
ber, 2015 19:49
> To: SQLite mailing list
> Subject: Re: [sqlite] about compile configure
>
> >pragma mmap_size= 51200;
> >Pragma page_size = 8192;
> >Vacuum;
> >Pragma cache_size = N;
>
> The testing result shows that the above pragma statements could
about sqlite3_exec(m_pDB, "PRAGMA synchronous = OFF;", 0,0,0);
The testing shows that It can not improve the speed of retrieving records from
data base.
Thank Simon all the same.
At 2015-12-21 18:20:49, "Simon Slavin" wrote:
>
>On 21 Dec 2015, at 10:07am, ??? <2004wqg2008 at 163.co
The SQL statement is so easy.
the table create statement as following:
CREATE TABLE poiTable (poiId INTEGER NOT NULL, versionId INTEGER NOT NULL,
regionId INTEGER , postalCode TEXT , phone TEXT , attrBitMask INTEGER ,
attributeBlob BLOB , primary key (poiId));
So the poiId is equa
What Simon said is very helpful for me. Thank you very much.
I only want to improve the speed of reading data from data base. Do not do
insert?update and so on.
I will try the following suggustion.
PRAGMA synchronous = OFF
Best regards
At 2015-12-21 17:03:13, "Simon Slavin" wrote:
>
>
>What do you mean "how to use sqlite_table"? Do you mean how to design
>effective database tables and query them efficiently using SQL?
The meaning of "how to use sqlite_table" is that I guess the sqlite_table may
have contained some information which could help to improve speed.
I am not
>Is your speed problem with a SELECT ? If so, can you past your SELECT into a
>message for us ? The speed problem has nothing to do with a SELECT
>Are you using multiple threads or multiple processes ?
NO
At 2015-12-21 12:53:09, "Simon Slavin" wrote:
>
>On 21 Dec 2015, at 4:23
hi,Simon.
The reason why I asked the question is that I want to improve the spped,
although the current SQLite is not too slow.
But the speed is not very ideal. So I still try any methods to improve the
performance of SQLite. I will try the following aspects:
first method , configure
Thank you very much.
At 2015-12-21 11:54:13, "Simon Slavin" wrote:
>
>On 21 Dec 2015, at 3:50am, ??? <2004wqg2008 at 163.com> wrote:
>
>> How about the following settings:
>
>Read the documentation for those settings. Given what they do which ones, if
>any, do you think will influence performa
How about the following settings:
SQLITE_DEFAULT_FILE_FORMAT=4;
SQLITE_MAX_ATTACHED=30;
SQLITE_ENABLE_COLUMN_METADATA;
SQLITE_ENABLE_FTS4;
SQLITE_ENABLE_FTS4_PARENTHESIS;
SQLITE_ENABLE_RTREE;
SQLITE_THREADSAFE=2;
NDS_ENABLE_ZLIB;
NDS_ENABLE_AES;
NDS_ENABLE_COLLATIONS
At 2015-12-21 11:42:14, "Si
hi,all
When we compile the sqlite source code, there are so many configuration,
such as
SQLITE_DEFAULT_FILE_FORMAT=4;
SQLITE_MAX_ATTACHED=30;
SQLITE_ENABLE_COLUMN_METADATA;
SQLITE_ENABLE_FTS4;
My question is that could different configuration influence the
On 21 Dec 2015, at 10:07am, ??? <2004wqg2008 at 163.com> wrote:
>CREATE TABLE poiTable (poiId INTEGER NOT NULL, versionId INTEGER NOT NULL,
> regionId INTEGER , postalCode TEXT , phone TEXT , attrBitMask INTEGER ,
> attributeBlob BLOB , primary key (poiId));
>So the poiId is equal to th
On 21 Dec 2015, at 6:19am, ??? <2004wqg2008 at 163.com> wrote:
> The meaning of "how to use sqlite_table" is that I guess the sqlite_table
> may have contained some information which could help to improve speed.
> I am not meaning to modify the data structure of sqlite_master.
There is no
On 21 Dec 2015, at 4:23am, ??? <2004wqg2008 at 163.com> wrote:
>first method , configure settings;
>second method , the other is how to use sqlite_table, could the
> sqlite_master table help us improve performance ?
Okay, now I can help you.
Neither of those things will help with speed
On 21 Dec 2015, at 3:56am, ??? <2004wqg2008 at 163.com> wrote:
> Thank you very much.
Why are you asking your question ? Is your program which uses SQLite too slow
? If so, how much too slow is it ? Just a little bit or a lot too slow ?
Simon.
On 21 Dec 2015, at 3:50am, ??? <2004wqg2008 at 163.com> wrote:
> How about the following settings:
Read the documentation for those settings. Given what they do which ones, if
any, do you think will influence performance ?
Simon.
On 21 Dec 2015, at 3:17am, ??? <2004wqg2008 at 163.com> wrote:
> When we compile the sqlite source code, there are so many
> configuration, such as
> SQLITE_DEFAULT_FILE_FORMAT=4;
> SQLITE_MAX_ATTACHED=30;
> SQLITE_ENABLE_COLUMN_METADATA;
> SQLITE_ENABLE_FTS4;
>
> The reason why I asked the question is that I want to improve the
> spped, although the current SQLite is not too slow.
> But the speed is not very ideal. So I still try any methods to improve
> the performance of SQLite. I will try the following aspects:
> first method , configure
26 matches
Mail list logo
