On 27 Aug 2012, at 18:51, Stephen Allen <[email protected]> wrote: >> Would it be possible to use a buffer? For small-ish result sets you would >> get the behaviour Andy suggests, but avoid the OOM issue. >> > > Something like setFetchSize() [1]? Oracle [2] defaults to 10 rows, > while PostgreSQL [3] and MySQL [4] both buffer the entire result.
Yep. In SDB we've tripped over the default behaviour of MySQL many times. Damian
