Interested to Buy Any Domain ? << Click Here >> for more details...
How cache is implemented in web application for DB queries?
- 2 Answers
- 5113 Views
- TCS, I also Faced
- E-Mail Answers
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
How do you pronounce c#?
State whether it is true to test a Web service you must create a windows application or Web application to consume this service or not?
What is lazy loading c#?
What is xml serialization in c#?
What is the use of protected in c#?
what is a enumeration in c#
What is null in database?
Why dependency injection is used in c#?
What is ac callback?
How long can a string be c#?
What is the c# equivalent of c++ catch (…), which was a catch-all statement for any possible exception? Does c# support try-catch-finally blocks?
What Happens In Memory When You Box And Unbox A Value-type?
What is oledbconnection c#?
Are structs value types c#?
What is private variable?
