I seeded the first 4 zoom level of the sqlite cache.

Here the sqlite version
https://www.traffwebdev.uk/parking/

here the disk version
http://www.buchananmapping.co.uk/

You can compare them from 5km to 200m (the scale in the bottom right), the rest 
is not cached. Bear in mind that the disk version is accessed over 80 website 
every day so there are people there all day while the sqlite you will be the 
only one as is setup just for test at the moment.

You can see that the sqlite version is almost 4 times slower, the only 
difference is that the disk is served over http and the sqlite over https.

Server setup:

-        CentOS 7

-        MapServer 6

-        mapCache 1.6

-        sqlite3 (3.7)

the 2 servers are exactly the same and I reimage them this august.

Sebastiano Laini
Web Developer
Buchanan Computing
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to