robert.fortin at autodesk.com
Tue Oct 9 16:12:24 EDT 2007
If I remember well, SDF doesn't index property other than the id.
So I don't think it would bring performance penalty.
From: fdo-internals-bounces at lists.osgeo.org
[mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Jason Birch
Sent: Tuesday, October 09, 2007 4:00 PM
To: MapGuide Internals Mail List; FDO Internals Mail List
Subject: RE: [fdo-internals] RE:
It would be nice if there was a way of specifying a case-insensitive
collation that could be used for things like sort and search, but I
guess I'll have to live with the workaround.
Is there a performance penalty to doing this (ie, does using this method
defeat any internal indexing)?
From: Robert Fortin
Subject: RE: [fdo-internals] RE: [mapguide-internals]
That change was done around March (in build 54), to make the "like"
operation consistent with the rest of the other operations.
It means "Like" is now case sensitive.
And yes, with this, it included support for lower and upper function so
that your call can be replaced with something like this
Upper(lastname) like 'SMITH%'
fdo-internals mailing list
fdo-internals at lists.osgeo.org
More information about the fdo-internals