[fdo-internals] Sorting in SDF?

[Robert Bray]

Actually I am not sure we are finished with the conversation on this list :)

I looked at the interface to SdfExtendedSelect which is almost, but not 
quite, identical to FdoISelect. Why not implement the optimized sorting 
in the standard command so that all clients can take advantage of it?

Turn that around for a minute. If every provider implements a 
<ProviderName>ExtendedSelect command, doesn't that diminish the value of 
FDO to client application developers? Why would I choose to use FDO if I 
have to write custom code for each provider?

Maybe we should revisit this command and consider rolling the behavior 
into the standard Select command implementation.

Bob


Jason Birch wrote:
> Ok, thanks, something to take up on the MapGuide list :)
> 
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org
> [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Badreddine
> Karoui
> Sent: Monday, February 05, 2007 11:35
> To: FDO Internals Mail List
> Subject: RE: [fdo-internals] Sorting in SDF?
> 
> I don't think it is. 
> 
> Badreddine
> 
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org
> [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Jason Birch
> Sent: February 5, 2007 2:21 PM
> To: FDO Internals Mail List
> Subject: RE: [fdo-internals] Sorting in SDF?
> 
> Interesting.  
> 
> Any idea if this is supported through the MapGuide APIs?
> 
> Jason 
> 
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org
> [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Badreddine
> Karoui
> Sent: Monday, February 05, 2007 11:17
> To: FDO Internals Mail List
> Subject: RE: [fdo-internals] Sorting in SDF?
> 
> It's actually not supported by the aggregate function and if it is
> enabled, then it probably would not perform. However the SDF provider
> has a custom command that supports sorting on multiple properties with
> different sorting parameter. This command is the SdfExtendedSelect
> command. This command is designed to perform and use less memory than
> the generic sorting algorithm provided in the FDO command.
> 
> Badreddine
> 
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org
> [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Pierre
> Dalcourt
> Sent: February 5, 2007 2:07 PM
> To: FDO Internals Mail List
> Subject: RE: [fdo-internals] Sorting in SDF?
> 
> Hi Jason,
> 
> Although the SDF capabilities state that ordering is not supported, it
> actually is supported by SDF Provider's SelectAggregates command.
> It just isn't supported by the Select command, so there was a decision
> to set the capability to say its not supported.
> Also, I'm not sure if there a performance issues for large sets that
> need to be sorted -- your mileage may vary.
> 
> Pierre
> 
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org
> [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Jason Birch
> Sent: February 5, 2007 2:00 PM
> To: FDO Internals Mail List
> Subject: [fdo-internals] Sorting in SDF?
> 
> Hi,
> 
> It looks like ordering is not supported in SDF?
> 
> Any idea what it would take to add support for this?  It's pretty
> important for a couple apps I'm working on where I need multi-key sorts.
> 
> Jason
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
> 
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
> 
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
>