CODEWITHSUNDEEP
c#.netoracle-databaseoledb
Noppol
Noppol

Reputation: 69

What is the best method of .Net for access very large database?

Suppose that, I use Oracle database. If my table have a lot of data about 10k records. When I use OleDB to select data from that table in ASP.NET. It's very slow.

Is there any methods that better than OleDB Oracle client?

Upvotes: 1

Views: 366

Answers (2)

user123664
user123664

Reputation:

Accessing 10k rows is not much. If it is for analytical reasons that you want to make calculations based on the data, use Oracle Analytical functions. They are VERY powerfull. By the time you accessed all rows and passed them to the client to have the analysis done on the client, the analysis has already been done by Oracle. Do the analysis as close to where your data is as possible: in the rdbms.

See Dan's library Oracle documentation ask Tom

Upvotes: 3

Mark Cidade
Mark Cidade

Reputation: 99997

Oracle Data Provider for .NET is a native implementation.

Upvotes: 3

Related Questions