OracleCommand cmd = new OracleCommand(SQL, conn);
OracleDataReader dr = cmd.ExecuteReader();
grd1.DataSource = dr;
grd1.DataBind();

Data Reader gets the executed data but when it hits grd1.DataBind(); it takes a very long time.  My query is returning 3000 rows with no paging.

Is there a good way to speed this up without paging?

Thank You

what about giving a try to optimize sql query itself?

btw read this article as well

http://www.oracle.com/technology/pub/articles/mastering_dotnet_oracle/williams_refcursors.html

garuka,

The query is real quick.  It comes back in a few seconds then sits on the databind for a long time.

I was sure it was the query but when I run "OracleDataReader dr = cmd.ExecuteReader(); " it comes back almost instantaly.

But the binding of the 3000 rows is taking forever.

Is there a way to optimize the binding?

Thanks

What type of query is this?

What about using other option like

• ExecuteNonQuery
• ExecuteScalar

This link states what to use when

http://blogs.x2line.com/al/archive/2007/05/01/3049.aspx

Also just read

http://www.vb-helper.com/howto_net_enhance_executereader.html

garuka,

It is a normal select query.  I'm just pulling out data from an oracle db then displaying it in a grid.

ExecuteReader would be the best way to go in that situation correct?

Thank You