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 |
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
How to find the given query is optimised one or not?
What do you know about ADO.NET's objects and methods?
Which provider is used to connect ms access, oracle, etc…?
What is Serialization in .NET? what are the types of Serialization?
What is ado or jdbc?
what is trigger?
8 Answers Microsoft, Precept Technology,
Differentiate between Dataset and Recordset.
What is the full form of ado?
What is the difference between oledb sql server and oledbdotnet provider?
What are the advantage of ado.net?