[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mapserver-dev
Subject:    [mapserver-dev] MapCache MBtiles insert speed
From:       Jirka Danielka <jezza1211 () gmail ! com>
Date:       2020-06-05 14:51:05
Message-ID: CAJcj_mgazpn2KjfAKQxzsqQ19JNQbE5k4nGbpJODfJnCLyqx-Q () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hello,
I have experimented with MapCache and MBtiles cache format and I have a
question.  I tuned my server with PostGIS and Mapserver to very good speed,
when I selected the cache type to disk. I got on aprox. 1800 tiles/s during
mapcache_seed process (with switches -n 12 -M 15,15). But when I changed
cache type to MBtiles, I got only aprox. 250 tiles/s. Is it normal speed
for SQlite cache? I tried to tune some pragma values like:
            <pragma name="journal_mode">MEMORY</pragma>
            <pragma name="synchronous">OFF</pragma>
            <pragma name="temp_store">MEMORY</pragma>
but i gained only +50 tiles/s more...
Thank you for your answer and help
George

[Attachment #5 (text/html)]

<div dir="ltr">Hello,<br>I have experimented with MapCache and MBtiles cache format \
and I have a question.   I tuned my server with PostGIS and Mapserver to very good \
speed, when I selected the cache type to disk. I got on aprox. 1800 tiles/s during \
mapcache_seed process (with switches -n 12 -M 15,15). But when I changed cache type \
to MBtiles, I got only aprox. 250 tiles/s. Is it normal speed for SQlite cache? I \
tried to tune some pragma values like:<br>                  &lt;pragma \
name=&quot;journal_mode&quot;&gt;MEMORY&lt;/pragma&gt;<br>                  \
&lt;pragma name=&quot;synchronous&quot;&gt;OFF&lt;/pragma&gt;<br>                  \
&lt;pragma name=&quot;temp_store&quot;&gt;MEMORY&lt;/pragma&gt;<br>but i gained only \
+50 tiles/s more...<br>Thank you for your answer and help<br>George<br></div>


[Attachment #6 (text/plain)]

_______________________________________________
mapserver-dev mailing list
mapserver-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-dev

[prev in list] [next in list] [prev in thread] [next in thread]