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
9995 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

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 the main difference between ADO and ADO.Net

4 Answers HCL,

What is data adapter in ado.net with example?

0 Answers

Define the data provider classes that is supported by ado.net?

0 Answers

What is two way data binding android?

0 Answers

What is difference between datatable and dataset?

0 Answers

Which database is the ado.net sql connection object designed for?

0 Answers

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

0 Answers

Which is the best institute in navi mumbai to learn DotNet

2 Answers

What is sqlconnection and sqlcommand?

0 Answers

i making a project using windows application c#, i want to show user name, password, and one button login. i wanna make it with sealed class .how its possible . when i clicked my login button all project should be open. pls cleare me.

1 Answers

What is the difference between linq and ado.net?

0 Answers

What is ambient transaction?

0 Answers

For more ADO.NET Interview Questions Click Here