[postgis-devel] GUI Speed

[Paul Ramsey]

I found one massive speed problem in the GUI (updating the progress bar way too often) and removed it, but the GUI is still a good ten times slower than shp2gpsql | psql at loading files. My current profile seems to show we are spending piles of time in transaction processing? (all the time is in the postgres process, the gui process itself isn't the bottleneck anymore) Perhaps there's something wrong with the way we're using libpq for this? A profile taken against a shp2pgsql load just shows that tuple compression in the lz routines is taking the time, which seems acceptable.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: screenshot_02.png
Type: image/png
Size: 88199 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20100709/70cf7f96/attachment.png>
-------------- next part --------------


--
Paul Ramsey
OpenGeo - http://opengeo.org
PostGIS makes my breath minty fresh.