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

Categories >> Software >> Microsoft Related >> ADO.NET
Suggest New Category

Question Posted / chaiturocks

5 Answers
8984 Views
Honeywell, I also Faced
E-Mail Answers

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