How cache is implemented in web application for DB queries?
Answer Posted / amar&venky
1)Memory or disk caching can be used directly to avoid running duplicate queries. A complex data report, for example, can have its result sets serialized to disk for reuse in multiple page templates. Caching has its own overhead, such as the expense of reading and parsing data on disk, so simple and inexpensive queries are most often best left for the database to process.
2)ORM modules can be built to retain objects in memory. For the first request, the data object is loaded into memory. Any updates or further requests can be managed in memory, with data written back to the database immediately or later, such as during system shutdown. In this way the ORM is effectively a buffer between the web application logic and the database server.
3)Caching partial page content can help avoid rerunning queries when that content is required multiple times.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What problem does Delegate Solve?
What is join in c#?
What is the difference between array and list in c#?
what is difference between destruct or and garbage collection ?
How to generate strong name key file or which command is used to generated strong name key file?
What is msil, and why should developers need an appreciation of it if at all?
Does c# have a 'throws' clause?
What is the diff between System.String and System.Text.StringBuilder classes?
What is int16?
What are c# attributes and its significance?
What is meant by unicode characters?
How do you clear a list in c#?
What is datacontract in c#?
What is a race condition?
Why do we use delegates?