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

Answer Posted / vinay kumar dubey

If we have lot of records to handle with safly and fastly
we must use Triggers ,Stored procedure to maintain
accuracy ,and Indexing for fast retrival of data

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to enable and disable connection pooling?

509


What is method to get XML and schema from Dataset? getXML() and get Schema ()

543


Explain the difference between data reader and data set?

486


What is ado data control?

521


What is the difference between data reader and data adapter?

534






How can we add/remove row's in "datatable" object of "dataset"?

539


What is sql command in ado net?

501


What is bubbled event?

535


Can we do database operations without using any of the ado.net objects?

535


What is ado or jdbc?

516


What is the difference between executequery and executenonquery?

508


What is typed dataset ?

678


How do you connect to sql server database without using sqlclient?

562


What is Dataset Object?

561


How to add a check box or a dropdown list to a column in a datagrid?

535