How to Fill DataSet with more records (around 1 lakh) in a faster way

SubQuery , Csharp , MySql , DataSet , Fill India
  • 9 years ago

    Dear All,

            We have a windows application. In this we are filling a mysql subquery results into dataset. But due to more records(around 1 lakh) it was taking too much time to fill and our database is mysql and we are filling the dataset using mysqlDataAdapter. Please anybody tell me how to fill dataset with more  records with in few seconds. Even we have tried with datareader but using datareader also taking too much time to read.
    

    Any Help Must be appreciated.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Computer Science is no more about computers than astronomy is about telescopes.” - E. W. Dijkstra