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
What is the difference between dataset and datatable?
Explain the various objects in dataset.
What Is Difference Between Ado And Ado.net?
What are the usages of the command object in ado.net?
What is difference between executequery and executeupdate?
What is a datagridview?
Explain the difference between an ado.net dataset and an ado recordset?
What is microsoft ado.net?
How to connect and retrieve data from database using dataset
What is the significance of CommandBehavior.CloseConnection ?
What is the difference between ado.net and oledb?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What are the major challenges in accessing data from a database?
Explain the different row versions available in table?
What is defaultview in datatable?