Hi
I am using Visual Basic with Identity Manager 7.1.1 to query the OneIdentity database along the following lines:
entries = Connection.CreateCol(table)
entries.Prototype.WhereClause = ...
entries.Load()
For each colElement As IColElem In entries
consume(colElement.Create())
Next
When I submit a simple table query to produce 15000 hits the query itself takes about 0.5 seconds but the conversion of all items from IColElem to ISingleObject by using the IColElem.Create() method takes about 50 seconds --- which is not tolerable for our case.
When applying PrepareBulkLoad() it still takes 12 seconds.
However, extracting the results manually from IColElem without using Create() is extremely fast --- but possibly not reliable.
Questions:
- is there an efficient official method to extract queries, better than using PrepareBulkLoad() on IColDbObject?
- is it reliable to extract the data manually by using the DisplayPattern in IColDbObject.EntityColDbObject.EntityPrototypeSingleDbObject?
Thanks a lot
Matt
