[Qgis-developer] Re: PostgreSQL performance

[Martin Dobias]

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