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 concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What are the advantages and drawbacks of using ado.net?
What is command class in ado.net?
What is namespace in ado.net?
What are the types of databinding?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.
2 Answers Fulcrum Logic, Satyam,
What is dataset and datatable in ado.net?
can we execute trigger normally at the desired time?
What is an ado?
How would you connect to database using .NET?
how can implement dropdownlist in particular of dataset when try to update?
can u tell me the how to get the print for the form