Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Travis Kirstine
My experience with SQLite is that it is significantly slower than a disk based cache. My guess is this is related to how mapcache structures the transaction and inserts into the sqlitedb. It appears that the mapcache creates a transaction based on the defined in the config, if the metatile is se

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
This is my cache setup /var/www/path/maps/cache/{tileset}/{grid}/{z}/{x}-{y}.sqlite3 1 1 1573741823 this is a custom grid I made up for an example EPSG:27700 128 128 0

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
Hi, It appears in both ways, when I'm seeding and when is requested from a pre-seeded cache, today I can't because I need to move the dev domain in another server but tomorrow I will pass you the link to the 2 cache so you can see the difference. Tonight I will let it seed the whole area. The

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Rahkonen Jukka (MML)
Hi, In which way does the slowness appear? Is it when seeding or when serving from a pre-seeded cache? Can you give metrics about the difference in speed? In this comparison the differences were rather small http://blog.sogeo.services/blog/2016/07/01/mapcache-disk-vs-sqlite.html Also by the do

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
Is there a way to improve the speed and match the speed of the sqLite3 cache with the disk one? We have 80 websites connected to MapCache and when I tried the sqLite3 I was testing it just on one website and on a complete different server with nothing in it. Sebastiano Laini Web Developer Buch

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
Still it redirect you to that link, and btw it seems that mapcache can be used also as a fastCGI. https://mapserver.org/mapcache/install.html#cgi-fastcgi-specific-instructions Though is true that I'm reading now in the CMaker Builder section MapCache can run as a FastCGI executable. Note that t

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Rahkonen Jukka (MML)
Sorry, MapCache documentation has link to that page as well. Anyway, my understanding is that Apache module is the fastest alternative and cgi/fcgi exist mainly to be used with other http servers than Apache. Keywords from presentation https://www.slideshare.net/tbonfort/modgeocache-mapcache-a

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Rahkonen Jukka (MML)
Hi, That documentation is about Mapserver, Mapcache is another software. It does belong to the same Mapserver but is not the same. MapCache is documented here: https://mapserver.org/mapcache/index.html#mapcache -Jukka Rahkonen- Lähettäjä: Sebastiano Laini [mailto:sebastiano.la...@buchanancompu

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
Well, for what I can read in the documentation of mapserver: https://mapserver.org/optimization/fastcgi.html FastCGI is a protocol for keeping cgi-bin style web applications running as a daemon to take advantage of preserving memory caches, and amortizing other high startup costs (like heavy da

Re: [mapserver-users] mapcache fastcgi

2018-10-17 Thread Rahkonen Jukka (MML)
Hi, Could you explain your plan with some more details? What I have understood is that you have experienced that SQLite cache is slower than disk cache in your environment. What I do not understand is what you are going to reach by running Mapcache as fastcgi instead of running it as Apache mo

[mapserver-users] mapcache fastcgi

2018-10-17 Thread Sebastiano Laini
Hi all, In the end I tried MapCache with sqlite3 cache but it's very slow compared with the disk cache, so I want to setup MapCache with fastCGI on CentOS 7. I don't understand what I need to install as the fastCGI link in the documentation is broken and I don't know if is up to date. I alread