Click here to Skip to main content
Rate this: bad
good
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 4:14am
Comments
Rajesh Puli at 26-Dec-11 9:17am
   
can you post you query, use Performance tuner to tune your query
Rate this: bad
good
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.
  Permalink  
Comments
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
good
Please Sign up or sign in to vote.

Solution 2

Hi,
 
You can also archive your old data if not required and also try to De-normalize if possible.
 
thanks
-amit.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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

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

  Print Answers RSS
0 OriginalGriff 277
1 Maciej Los 240
2 DamithSL 200
3 Raul Iloc 185
4 Richard MacCutchan 175
0 OriginalGriff 5,130
1 DamithSL 4,197
2 Maciej Los 3,670
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,821


Advertise | Privacy | Mobile
Web02 | 2.8.141216.1 | Last Updated 5 Aug 2014
Copyright © CodeProject, 1999-2014
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