Click here to Skip to main content
11,636,213 members (73,187 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 295
1 Sergey Alexandrovich Kryukov 275
2 OriginalGriff 233
3 Suvendu Shekhar Giri 225
4 stibee 215
0 OriginalGriff 8,941
1 Sergey Alexandrovich Kryukov 8,459
2 Mika Wendelius 6,849
3 F-ES Sitecore 2,364
4 Suvendu Shekhar Giri 2,320

Advertise | Privacy | Mobile
Web03 | 2.8.150728.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