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

[Bruce Dechant]

The reason the SetOrderingFilter() API doesn't work with SDF is because
the SDF provider doesn't support it. We don't call any special provider
only commands in MG and so calling the SdfExtendedSelect command is not
really a good solution. What should be done is update the SDF provider
to support ordering natively like most of the other FDO providers.

Bruce

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Andy
Morsell
Sent: February 5, 2007 1:11 PM
To: 'MapGuide Internals Mail List'
Subject: RE: [mapguide-internals] FW: [fdo-internals] Sorting in SDF?

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



_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals