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

Ray ray.wu at efacec.com
Tue Nov 30 16:08:57 EST 2010

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

#1: (bind the string filter but supply different ufid for each query) 
Dim filterString As String = String.Format("( UFID = {0} )", ufid) 

#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.

More information about the fdo-users mailing list