Optimizing fetch of big result set - HELP!

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

This message: [ Message body ]
Next message: Jonathan Lewis: "Re: Optimizing fetch of big result set - HELP!"
Previous message: Reiner: "Re: newbie: copy records from one table to another"
Next in thread: Jonathan Lewis: "Re: Optimizing fetch of big result set - HELP!"
Reply: Jonathan Lewis: "Re: Optimizing fetch of big result set - HELP!"
Reply: dbahelp: "Re: Optimizing fetch of big result set - HELP!"
Reply: Sybrand Bakker: "Re: Optimizing fetch of big result set - HELP!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US