Which of the following is faster and consume lesser memory?

Options
- SQLDataReader
- Data Set


CORRECT ANSWER : SQLDataReader

Discussion Board
answer

Answer is DATAREADER as it fetches only one row at a time.

Ankita 10-23-2022 03:34 AM

answer

Answer is DATAREADER as it fetches only one row at a time whereas Dataset stores it as a table as whole.so it need much more network resourses.

Neethu 07-17-2018 02:04 AM

Online Practice Test >ASP.NET « Previous Next » Which of the following is faster and consume lesser memory?


Sqldatareader is fast as compare to Dataset.Because it stored data in forward only and also stores only one record at a time.And dataset stores all records at the same time.This is the reason, SqlDataReader is faster than Dataset.

pranav 06-28-2017 12:27 PM

no satisfy with answer

Please give me the best answer that sqldatareader is faster than Dataset.

Deepak singh 06-16-2015 03:35 PM

Verify

SQLDataReader can not be fast because it always require open connection till reading is not completed from database but yes it uses less memory

Ashok kumar 03-11-2015 06:38 AM

answer.

kindly share the answer of the multiple choice of question.

anwer 08-21-2014 07:43 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement