CODEWITHSUNDEEP
c#.netoracle-database
Garry
Garry

Reputation: 1

Oracle Data Provider adapter fill takes forever

I have a .net (C#) DAL layer in my application which uses Oracle Data Provider (The System.Data.Oracleclient Version) to Retrieve results from the DB.

I have a problem that somtimes queries which take seconds to complete when executed via PLSQL take forever to complete with the method Adapter.Fill(Table) this is causing us lots of problems and we have no idea what's causing it.

Any Idea anyone? help will be greatly appriciated

Thanks

Upvotes: 0

Views: 578

Answers (2)

tsells
tsells

Reputation: 2771

If you are using Toad to run the query it will return a sub set of data and then continue filling until complete. Are you querying text data? What happens if you change your result to a count(*) versus the actual fields? Does that change the timings?

Upvotes: 0

DCookie
DCookie

Reputation: 43533

When you say it "takes seconds to complete when executed via PLSQL" is that the time to return all rows selected by the query, just the first 20 or so? How many rows are returned by the query in total?

Upvotes: 1

Related Questions