You must Sign In to post a response.
  • Category: ASP.NET

    Which is faster data access technology

    hi greeks,

    I have 1 lakh row in a table .i want to faster data access.then which technology is used to get faster data.

    thank you in advance

    abhijit patil
  • #763284
    Hi Abjijit
    If you want to fetch data faster there are copuple of ways to do it
    1. Fetch data in dataset and then you can fire query on dataset to fetch desired record, it will speed up your application
    2. Fetch data in dataset and create XML with dataset and then use LINQ to fetch data from XML, it will boost application performance
    Microsoft recommended DataReader rather than dataset as it is connected architecture and does not contain data in memory
    hope it helps

    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • Sign In to post your comments