SPAM!!!: SPAM!!!: Re: SPAM!!!: Re: [UMN_MAPSERVER-USERS] JOIN / ODBC

[Sylvain Beorchia]

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" <warmerdam at POBOX.COM>
To: <MAPSERVER-USERS at LISTS.UMN.EDU>
Sent: Wednesday, November 23, 2005 5:20 PM
Subject: SPAM!!!: Re: [UMN_MAPSERVER-USERS] JOIN / ODBC


On 11/23/05, robert fritz <robert-fritz at web.de> 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, 
warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent