[fdo-users] RE: How to boost ISelect and IUpdate command performance

[Traian Stanev]

I don't know enough about how the Oracle FDO provider handles queries internally, but I imagine that the way I proposed will not result in much optimization with Oracle as it would still have to translate the filter to some sort of Oracle query every time anyway, regardless of the input FdoFilter being cached.

So you may have to use some other kind of parameter binding, hopefully someone else on the list can help with that.

Traian


> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-
> bounces at lists.osgeo.org] On Behalf Of Ray
> Sent: Tuesday, November 30, 2010 4:09 PM
> To: fdo-users at lists.osgeo.org
> Subject: [fdo-users] RE: How to boost ISelect and IUpdate command
> performance
> 
> 
> The data source is Oracle.
> 
> My intention was to avoid sql statement re-parsing by using appropriate
> FDO
> api. I wonder if both the following approaches (#1 and #2) would
> achieve the
> same?
> 
> #1: (bind the string filter but supply different ufid for each query)
> Dim filterString As String = String.Format("( UFID = {0} )", ufid)
> selCmd.SetFilter(filterString)
> 
> #2: (use the same CamparisonCondition but set different ufid)
> Dim idname As Identifier = New Identifier("UFID")
> Dim val As Int32Value = New Int32Value(ufid)
> Dim cc As ComparisonCondition = New ComparisonCondition(idname,
> ComparisonOperations.ComparisonOperations_EqualTo, val)
> selCmd.Filter = cc
> 
> --
> View this message in context: http://osgeo-
> org.1803224.n2.nabble.com/How-to-boost-ISelect-and-IUpdate-command-
> performance-tp5788379p5789649.html
> Sent from the FDO Users mailing list archive at Nabble.com.
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users