Hi<br>I am designing a N-tier DCOM application using VB, Oracle and MTS. I have defined methods in the MT (Middle Tier) which are called from the UI (User Interface) to retrieve large amounts of data. As sending all the retrieved data back to the UI can create huge network traffic, I am looking for an alternate way to achieve this. I want to send the retrieved data back to the UI in parts rather than all together.<br><br>However this requires me to save the state of the retrieved data in the MT between the two successive calls of the method for next chunk of rows. How can I do it? Also it will require me to save large Recordset objects in the MT for uncertain amount of time. Is it advisable to store large recordset objects in the MT or to requery the database when next chunk of rows are requested?<br><br>Thanks<br>Jatin<br><br>