There is a significant difference between needing to *work* with 200,000 records versus working with a subset of them. If you can create filters in the back end then you could significantly decrease the amount of data you need to transfer over the wire.

I haven't worked with batching techniques myself so I won't be much help there. I would agree that one would need to use the singleton pattern for the remote class. I assume the technique would be something like this:

1. Call remote object to start query to database, remote class stores full dataset locally
2. Call remote object to get a small set of records, remote class returns the small set from the full set
3. Use the small set in your app
4. Repeat steps 2-3 until all records are received.

I'm no remoting or data batch expert but that's how I would approach it.

-Peter