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?
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.