Optimizing fetch of big result set

From: Philippe Laflamme <plaflamme_at_konova.com>
Date: Wed, 25 Jul 2001 12:45:02 -0400
Message-ID: <cIC77.22126$eY6.2501085@news20.bellglobal.com>

Hello,
Does anyone have any clues as how to optimize fetching of data from a result set on one table?

Explanation:
I have a select statement that returns 3 columns and >200000 rows. Fetching all these rows (through OLEDB or ODBC) takes ~= 6 seconds...Which is too much. I'm already using bulk fetching with no luck (without bulk fetching it takes about 40 seconds). The select statement is only on one table.

What would be the possible ways to optimize the fetching of theses results?

Help please.... Received on Wed Jul 25 2001 - 11:45:02 CDT

Optimizing fetch of big result set - HELP!