I've got a question about speeding up the OO4O data transfer over network. I'm working on Oracle 8.1.7, Win2000 and Delphi 6.
I've got an SP that returns an Oracle object. This object contains a list of Oracle objects and it can be iterated through. Now, when I iterate through it and save the results elsewhere, it seems that the data is being transferred over the network at the same time as I'm accessing more items in the list. This is horribly slow.
Is it possible to get the whole object transferred at the time when I get the object, so there wouldn't be any transfers during the iteration? Or can the transfer block size be changed to a bigger one somehow?