Hi,
This works. I've tried it yesterday...that's really cool, i was looking for
that functionnality for a long time...
But it's very slow, very very slow.. or maybe i don't use it like i should
do ?
The only way i found to get it faster is to have a small shapfile, and a
small database....
If someone tried this method, and can give me any advices.
Thanks.
Sylvain B.
----- Original Message -----
From: "Frank Warmerdam" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, November 23, 2005 5:20 PM
Subject: SPAM!!!: Re: [UMN_MAPSERVER-USERS] JOIN / ODBC
On 11/23/05, robert fritz <[EMAIL PROTECTED]> wrote:
Hello,
it is possible to join a layer to an odbc database. i use the join to an
access database::
GROUP "G_BPLiv"
NAME "BPLiv"
TYPE POLYGON
STATUS ON
CONNECTIONTYPE OGR
CONNECTION "D:\MS_Data\fgt\data\shapes\satzungen\bplaene_iv.shp"
DATA "SELECT * FROM bplaene_iv LEFT JOIN 'ODBC:satz_blp'.satzungen ON
bplaene_iv.DB_ID = Satzungen.SATZUNGSID"
Robert,
I think this should work. I would suggest you
test it first with ogrinfo and see if that works.
eg.
ogrinfo -ro D:\MS_Data\fgt\data\shapes\satzungen\bplaene_iv.shp \
-sql "select ..."
If the Satzungen.SATZUNGSID field isn't indexed performance will
be very poor. In any event performance isn't likely to be great if you are
dealing with a very large number of features, since a new SELECT on
a particular ID will be issued to the ODBC datasource for each record
selected from the shapefile.
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam,
[EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent
