[Qgis-developer] Re: PostgreSQL performance

Martin Dobias wonder.sk at gmail.com
Thu Apr 2 18:08:26 EDT 2009


On Thu, Apr 2, 2009 at 11:33 PM, Jürgen E. <jef at norbit.de> wrote:
> Hi Martin,
>
> turns out to be much simpler than we thought: libpq does SSL by default
> and JDBC doesn't.

Hi Jürgen,

that's a great news!

> I made that configurable in the postgres connection dialog in r10456 and
> w/o SSL the rendering time for my sample layer with ~180000 polygons
> drops from 20s to 10s...

I've tested now with disabled ssl and really the change is biiig: my
layer with 190K lines goes from 25s to 9s.

Bye
Martin


More information about the Qgis-developer mailing list