[mapguide-internals] FW: [fdo-internals] Sorting in SDF?

[Andy Morsell]

There is already MgFeatureQueryOptions::SetOrderingFilter in the MOGS API,
but it doesn't work for SDF.  Works for Shapes though, if I remember
correctly.


Andy 

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Jason Birch
Sent: Monday, February 05, 2007 11:42 AM
To: MapGuide Internals Mail List
Subject: [mapguide-internals] FW: [fdo-internals] Sorting in SDF?

Hi all,

Please see below.

Apparently there is an advanced select mode in the FDO Provider for SDF that
would allow sorting.

Anyone know for sure that this is not supported via the MapGuide APIs and,
if it is not, whether it is something that we could look at?

Being able to sort results coming back from a query is pretty important.
It can be handled in code, but that tends to get pretty complex when you
start looking at multi-key sorts and paging.

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: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
_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals