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

[Ray]

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.