[Qgis-developer] [Server] performance questions

[aperi2007]

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 at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer