Hi Regis,
The shapefile is obviously more fast in opne than a postgres connection.
Is due to the different need of resources.
The postgres need to assign a lot of resources for every connection that
it is opening.
I do't know quite well the pgpool solution, but I guess it cannot
helpyou because AFAIK it is only for dirct connection.
You should set is with a fastcgis but you have heowever the problem that
postgres interrupt brutally the connection after some ten of minutes
without any byte exchanging with the clinet.
These mean that alsoif you use a fastcgi protocol but have a service not
used for more than 30 minutes it will break connection from postgres
side and so it need to restart the connection (and so take some time to
do it) when the user ask for a new map.
To avoid also all these questions we use the spatialite db that is fast
like a shapefile toopen and have no the problem of connection and break
of connection like the postgres.
A.
Il 23/02/2016 16:11, Régis Haubourg ha scritto:
Andrea Peri wrote
I Guess the time difference between the qgis desktop and qgis-server
when using a postgres,
is due to the protocol.
Infact the http is a connection-less session-less protocoll,
so after every map the qgis-server disconnect from postgres.
Instead when you work on a qgis desktop as a user on its own pc you
are connectin with a postgres and sray connected for all the time.
So the postgres don't waste time to open and staryup your connection.
Also don't forget that if you stay about 18-20 minutes without do
nothing on qgis in a postgres connection.
The postgres kill your connection and your qgis go in crazy state.
A.
Hi Andrea,
You are right for the overhead part. This would not big a big issue if we
did not have the overhead on postgres side for extent querying on SQL views.
The same dataset in shape is open fast even at first connection.
We use pgpool here so we do not have such trouble with idle connections
being killed.
Cheers
Régis
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Server-performance-questions-tp5252233p5252247.html
Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.
_______________________________________________
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
_______________________________________________
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
