[Gdal-dev] OGR PostGIS driver BINARY CURSOR support
Oleg Semykin
oss-dev at rambler.ru
Sat Aug 6 10:53:08 EDT 2005
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 at 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 at 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.
More information about the Gdal-dev
mailing list