[mapguide-users] Which is better??

[Zac Spitzer]

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.Milicevic at 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-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at 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.Milicevic at supranet.hr> wrote:
>> Zac,
>>
>> and what about displaying data from SDF vs same data from SQL Server?
>>
>> -----Original Message-----
>> From: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at 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 <anakando at 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 at 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 at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



-- 
Zac Spitzer -
http://zacster.blogspot.com
+61 405 847 168