ivan, i agree with you. sdf performance is much better than read layer geometry from database. but if your requirement need an up-to-minute data(attribute), maybe joining sdf to datbase is not the best choice
zspitzer wrote: > > 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 > > -- View this message in context: http://n2.nabble.com/Which-is-better---tp2126726p2127018.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