joins are lame because for 100 rows it does a 100 sub queries more of less doing it all with the db is simple way more efficent
z On Thu, Jan 8, 2009 at 8:04 PM, Ivan Milicevic <ivan.milice...@supranet.hr> wrote: > SDF is native Mapguide format, isn't it? So it's considerable to be > faster. > > We server about 10-20 users per server. > > -----Original Message----- > From: mapguide-users-boun...@lists.osgeo.org > [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Zac Spitzer > Sent: Thursday, January 08, 2009 9:22 AM > To: MapGuide Users Mail List > Subject: Re: [mapguide-users] Which is better?? > > a pure sdf solution generally speaking will be better, but a database > is way easier to manage > > how many users are you serving? > > z > > On Thu, Jan 8, 2009 at 7:01 PM, Ivan Milicevic > <ivan.milice...@supranet.hr> wrote: >> Zac, >> >> and what about displaying data from SDF vs same data from SQL Server? >> >> -----Original Message----- >> From: mapguide-users-boun...@lists.osgeo.org >> [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Zac > Spitzer >> Sent: Thursday, January 08, 2009 8:45 AM >> To: MapGuide Users Mail List >> Subject: Re: [mapguide-users] Which is better?? >> >> if your joining, do in the database, mapguide joins aren't much chop >> >> a database will scale and be faster and more reliable... >> >> does all depend on your data of course and how much you have >> >> On Thu, Jan 8, 2009 at 6:24 PM, irwan <anaka...@yahoo.com> wrote: >>> >>> Hi guyss. here is the situation.. >>> >>> 1. Publish a pole layer (sdf file) that joined with attribute from >> database >>> using MGStudio >>> 2. Publish both pole attribute and spatial data from database (store >> pole >>> geomtery coordinate) using MGStuido >>> >>> >From your point of view, which one comes up with a better >> performance?? I >>> know your asnwer and explanation is very useful for someone out there >> who >>> are very care about the performance >>> >>> Cheers >>> -- >>> View this message in context: >> http://n2.nabble.com/Which-is-better---tp2126726p2126726.html >>> Sent from the MapGuide Users mailing list archive at Nabble.com. >>> >>> _______________________________________________ >>> mapguide-users mailing list >>> mapguide-users@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >> >> >> >> -- >> Zac Spitzer - >> http://zacster.blogspot.com >> +61 405 847 168 >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> > > > > -- > Zac Spitzer - > http://zacster.blogspot.com > +61 405 847 168 > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > -- Zac Spitzer - http://zacster.blogspot.com +61 405 847 168 _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users