[Qgis-developer] PostgreSQL performance

Jürgen E. Fischer jef at norbit.de
Thu Apr 2 17:33:35 EDT 2009


Hi Martin,

turns out to be much simpler than we thought: libpq does SSL by default
and JDBC doesn't.

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...


Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-20
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502



More information about the Qgis-developer mailing list