> But doesn't turning it off cause the entire recordset to come back at once?
Yes, it does.
> I seem to remember having problems with Declare/Fetch, after turning it
> off I had a huge performance boost when running large reports.
I have a huge performance reduce with turning off Declare/Fetch.
It depends what you want and how is the app written.
Regards,
Luf