Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language

Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Asp.Net Programming

What is the fastest way to pull data from an Oracle table?


I have a pretty large table (22,000 rows, 40 columns) that I need to return
to either a webpage (maybe a datagrid or just a table) or just spit out
directly to Excel. This table is coming from an Oracle database.

The code we are using now uses the Enterprise Library and using the
ExecuteDataSet method. I tried the ExecuteReader, but that didn't seem any
faster. When I use the ExecuteReader my assumption is that I still need to
get it into either a DataTable or DataSet in order to do anything with it. I
haven't found a real good and/or fast way to do that. I can do it, but I
don't image it is very optimized.

What I don't understand is that if I use a query tool, such as Toad or SQL
Navigator, I can pull the entire table in about 10 seconds. If I pull it
through .NET it can take as long as seven minutes. That is even if I just
iterate through the rows, not returning them to a page, just a running count
on my Immediate window. I guess there is much more overhead with .NET, but I
am surprised at such a big difference in time.

My guess is that the Enterprise Library may be slowing things down, but I
have no proof of that or any way to confirm those suspicions.

I would really appreciate any suggestions on getting this to work faster.

Thank you.


p.s. We are using .NET 1.1

On Feb 8, 8:46 am, "Gummy" <gumbat@hotmail.com> wrote:

Data Retrival using DataReader is the fasted method....
But according to your post it seems you are having problem with
datareader also...
try use oracles dataprovider.... developed by oracle




Thank you for the link!

"Masudur" <munn@gmail.com> wrote in message


Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc