[mapguide-users] Which is better??

[irwan]

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.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
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at 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.