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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / naren

Increase the execution timeout in ADO.NET

Is This Answer Correct ?    9 Yes 1 No

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

Answer / 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

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

Answer / ashish bharadwaj

You can set this value in web.config. For example, to
change the timeout for one specific page:

<location path="somefile.aspx">
<system.web>
<httpRuntime executionTimeout="180"/>
</system.web>
</location>



Hope that helps.

Ashish Bharadwaj,Noida(delhi)
mail:-ashishsrm85@gmail.com

Is This Answer Correct ?    1 Yes 1 No

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

Answer / pavithra

yes

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

0 Answers  


What are the advantages and drawbacks of using ado.net?

0 Answers  


What is command class in ado.net?

0 Answers  


What is namespace in ado.net?

0 Answers  


What are the types of databinding?

0 Answers  






I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.

2 Answers   Fulcrum Logic, Satyam,


What is dataset and datatable in ado.net?

0 Answers  


can we execute trigger normally at the desired time?

3 Answers   Microsoft,


What is an ado?

0 Answers  


How would you connect to database using .NET?

0 Answers  


how can implement dropdownlist in particular of dataset when try to update?

0 Answers   TCS,


can u tell me the how to get the print for the form

2 Answers   Crea,


Categories