[GRASS5] Re: [Gdal-dev] OGR PostGIS driver BINARY CURSOR support

GRASS GIS GRASS GIS developer
,
1

This FWD from GDAL-dev is probably of interest here.

http://lists.maptools.org/pipermail/gdal-dev/2005-August/thread.html#6122

Markus

On Sat, Aug 06, 2005 at 06:53:08PM +0400, Oleg Semykin wrote:

Hi, Frank!! Hi ALL!

I am just finished the binary cursor support for PostGIS.

This support is switched off by default.
To switch it ON, you have to replace two first character of driver
string ('PG') with ('PGB') -> PG Binary

For example:
ogrinfo 'PGB:host=192.168.17.3 dbname=lenobl user='postgres' password=''
port=5432' t_table_10

Everybody is welcome to test this feature for a bugs and performance.

I am have tables with only ~5000 records of complex geometries (
MULTIPOLYGON)
And that is my results:

oss@oss:~/work/gis/gdal$ time ogrinfo 'PG:host=192.168.17.3
dbname=lenobl user='postgres' password='' port=5432' t_table_10 >
/dev/null 2>&1

real 0m17.252s
user 0m2.214s
sys 0m0.162s

oss@oss:~/work/gis/gdal$ time ogrinfo 'PGB:host=192.168.17.3
dbname=lenobl user='postgres' password='' port=5432' t_table_10 >
/dev/null 2>&1

real 0m9.504s
user 0m1.969s
sys 0m0.165s

I would be very thankful for any suggestions.