IF we have lot of records in Database. How we can handle them?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
What is connected architecture in ado.net?
Diff. b/w DataReader and DataSet?
What are the parameters that control most of connection pooling behaviors?
How to fetch the last inserted record in a particular table?
10 Answers CarrizalSoft Technologies, Microsoft,
What is Debug.write does?
Which database is the ado.net?
What is the default Timeout for SqlCommand.CommandTimeout property?
What are the ADO.NET Controls?
How to generate XML from a dataset and vice versa?
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?