[Qgis-developer] Re: PostgreSQL performance

[Tim Sutton]

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