We help IT Professionals succeed at work.

Timeout Exception while retrieving large amount of data from oracle db using .net code

guvera
guvera asked
on
Medium Priority
862 Views
Last Modified: 2012-08-14
Hi,

I have more than 30,000 records in my database and i have to display it as excel sheet, for that i have retrived the data as dataset and then converted it to excel.But if i am retrieving 1000 or more no of rows its taking large amount of time, some time timeout exception is occuring.

I am using oracle as backend and c# as front end, if anybody knows the solution rply.

Comment
Watch Question

Commented:
Change the connection timeout setting to a larger value on the command object first and see if that helps otherwise you can change the timeout on connection object

Eg.
oCmd.Timeout = 180;   // oCmd Command Object

oConn.Timeout = 180;  //oConn Connjection Object

Author

Commented:
Is there any solution to reduce the loading time. (loading the data from db server)?

Commented:
Do not fully understand what you mean. The performance of your query will depend on how the query is optimized and what your infrastructure is. I have queries return result with more than 100,000 results in about 3-5 seconds

Author

Commented:
How can i optimize the query, In my query one view is creating by selecting the all values from the table and some other user defined functions.In user defined functions each id from the table is passing and corresponding values are retrieving using cursor.Finally in stored procedure some fields are selecting from this view -based on some conditions.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
This would helpful to me partially.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.