[Qgis-developer] Re: PostgreSQL performance
Tim Sutton
lists at linfiniti.com
Fri Apr 3 18:35:00 EDT 2009
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi
Martin Dobias wrote:
> 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.
>
Drawing my roadlines of South Africa layer which has 1 137 339 features
used to take 2 mins 15 sec to render. It now renders in 1min5 secs.
Aaaawwwweeeesooommmeee :-)
Regards
Tim
> Bye
> Martin
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
- --
Tim Sutton - QGIS Project Steering Committee Member (Release Manager)
==============================================
Please do not email me off-list with technical
support questions. Using the lists will gain
more exposure for your issues and the knowledge
surrounding your issue will be shared with all.
Visit http://linfiniti.com to find out about:
* QGIS programming and support services
* Mapserver and PostGIS based hosting plans
* FOSS Consulting Services
Skype: timlinux
Irc: timlinux on #qgis at freenode.net
==============================================
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAknWjw0ACgkQqk07qZdiYjdeOQCgh6GuoUgnYz9Ydgr6s/3peUng
T/cAn0v4zixGx1FcQQCa97tutxdTR6f0
=zrvu
-----END PGP SIGNATURE-----
More information about the Qgis-developer
mailing list