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

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

4 Answers  


What is connected architecture in ado.net?

0 Answers  


Diff. b/w DataReader and DataSet?

8 Answers   Avon, Value Labs,


What are the parameters that control most of connection pooling behaviors?

0 Answers  


How to fetch the last inserted record in a particular table?

10 Answers   CarrizalSoft Technologies, Microsoft,






What is Debug.write does?

1 Answers  


Which database is the ado.net?

0 Answers  


What is the default Timeout for SqlCommand.CommandTimeout property?

0 Answers  


What are the ADO.NET Controls?

6 Answers  


How to generate XML from a dataset and vice versa?

2 Answers  


How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

0 Answers   SwanSoft Technologies,


What do you know about ado.net's objects?

0 Answers  


Categories