Click here to Skip to main content
11,704,315 members (46,354 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: Windows Oracle VB.NET
I am developing a windows application using VB.Net with Framework 4.0 using oracle database and my application fetch data from Oracle 11g database using OleDb Connection and paste these data into excel sheet.

But My Problem is that the Fetching Data from Application take too much time because there are lot of data. I use join with 10 table and each table contain more than 10000 of record.

Please suggest me how I get data fast.
Posted 26-Dec-11 3:14am
Rajesh Puli at 26-Dec-11 9:17am
can you post you query, use Performance tuner to tune your query
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Improving your database design (indexes, keys, relationships, and queries) is pretty much your only hope. Of course you already knew htis, so your question ends up being pointless.
Hemant Sarraf at 26-Dec-11 13:44pm
to generate a single report hits is approx 400.
I want to know is there is any way like any other connection class like SqlCient to fetch data faster.
The various .Net classes don't do ANYTHING to improve the database itself. If you don't have the skills necessary to make the database perform at an acceptable level, hire a qualified DBA. I used to work in an Oracle database that contained several hundred tables with several million records, and our queries for ANYTHING took less than 3 seconds to perform. We had an Oracle DBA on staff.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2


You can also archive your old data if not required and also try to De-normalize if possible.

Rate this: bad
Please Sign up or sign in to vote.

Solution 3

Use Microsoft.Practices.EnterpriseLibrary. it is very fast compare with oledb..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 740
1 OriginalGriff 520
2 Maciej Los 355
3 Andy Lanng 284
4 CPallini 275
0 OriginalGriff 8,824
1 Sergey Alexandrovich Kryukov 8,247
2 CPallini 5,197
3 Maciej Los 4,726
4 Mika Wendelius 3,606

Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 5 Aug 2014
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100