>Thank all for replies to this. Something interesting I've just noticed after getting this working:
>
>When I create a session object and reference from it the DE and then addobject 8 cursors with 11 megabytes involved, the time to instantiate everything and open the cursors is about .3 seconds. If I do the same thing but addobject the session object to a custom object, the time for everything to occur is only .004 seconds. The data is really there also as I can access any of the tables!! That was quite a surprise. Any ideas on this?
Terry,
Are you measuring the same time interval for both of them? It is possible that the DE time includes the instantiation of the form, the DE, and the Session object.
Anyway with a difference of .296 seconds, I would go with the best logical design and forget about the time. It is not like you create these things 1,000,000 times in a loop.