IF we have lot of records in Database. How we can handle them?

Answer Posted / pavan kumar p

You can handle Large data by practicing some design
patterns like, using stored procedures rather than
Statements, Use coloum names rather tahn * when fetching
the statements etc..

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does ole stand for in excel?

598


What does executenonquery () method return?

498


What is openquery?

529


Explain the advantages and disadvantages of using datalist?

614


Explain the two fundamental objects in ado.net?

503






What is difference between ado and other data object?

468


What are ado.net objects?

531


What is the difference between ado.net and entity framework?

506


What is the DataTableCollection?

573


What are the various methods provided by the DataSet object to generate XML?

589


What is a datareader object?

579


Explain the difference between data reader and data adapter?

507


How to creating a SqlCommand Object?

591


How do you merge 2 datasets into the third dataset in a simple manner?

537


How do you update database through dataset?

537