Search Postgresql Archives

Re: Connection pooling

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/31/2013 3:24 PM, John R Pierce wrote:
On 10/31/2013 1:09 PM, andy wrote:
I'm not sure if geoserver is like openLayers/mapserver, but in the
later case (which I use), you can set it up to have the browser
(running openLayers) request multiple layers at the same time... and
on top of that each layer can be requested in tiles.  (That way when
you drag the map it only has to load new tiles, and not the entire
image, which makes the animations smooth)

Anyway, one webclient * 5 layers * tiles = lot and lots and lots of
web requests (which, would make lots of db hits).

sure, but those hits shouldn't each be using a new connection, no more
than 2-4 of them should be processed concurrently following http 1.1
guidelines, so no more than 2-4 connections should be required.

the behavior the OP descibed sounded like the tomcat applets aren't
closing their connections, thats broken behavior.




Ah, yes, you're right. Lots and lots of requests, but not all of them concurrently.

-Andy



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux