Home | Docs | Issue Tracker | FAQ | Download | |
- Use Spatial Indexes on your geometry/geography columns PostGIS Spatial Indexes.
- Index any column that could be used frequently as a filter
- General PostGIS Performance tips
- General PostgreSQL Performance tips
- Even more tips on Tuning PostgreSQL
Check that your TinyOWS is compiled with FastCGI support:
[user@host mapserver]$ tinyows --check TinyOWS version: 1.1.0 FCGI support: Yes ...
In Apache, activate mod_fastcgi
$ sudo apt-get install -y libapache2-mod-fastcgi $ sudo a2enmod fastcgiApache fast-cgi configuration:
#in your cgi-bin directive, add the following to run all cgi-bin using FastCGI SetHandler fastcgi-script #in your FastCGI config file (typically something like /etc/apache2/mods-enabled/fastcgi.conf) FastCgiServer /usr/lib/cgi-bin/tinyows.fcgi -processes 10
Please refer to the fastcgi doc in ms4w
Add the following 2 lines:
DefaultInitEnv TINYOWS_CONFIG_FILE "/ms4w/apps/tinyows/config.xml" DefaultInitEnv TINYOWS_SCHEMA_DIR "/ms4w/apps/tinyows/schema/"
In Apache, activate mod_deflate
Deflate basic configuration, (note we’re including xml so gml and json):
AddOutputFilterByType DEFLATE text/html text/plain text/xml application/xml application/json