How cache is implemented in web application for DB queries?
Answers were Sorted based on User's Feedback
Answer / bhanu, patna(bihar)
Many e-Business applications today are being developed and
deployed on multi-tier environments involving browser-based
clients, web application servers and backend databases. The
dynamic nature of these applications necessitates
generating web pages on-demand, making middle-tier database
caching an effective approach to achieve high scalability
and performance [3]. In the DBCache project, we are
incorporating a database cache feature in DB2 UDB by
modifying the engine code and leveraging existing federated
database functionality. This allows us to take advantage of
DB2's sophisticated distributed query processing power for
database caching. As a result, the user queries can be
executed at either the local database cache or the remote
backend server, or more importantly, the query can be
partitioned and then distributed to both databases for cost
optimum execution.DBCache also includes a cache
initialization component that takes a backend database
schema and SQL queries in the workload, and generates a
middle-tier database schema for the cache. We have
implemented an initial prototype of the system that
supports table level caching. As DB2's functionality is
extended, we will be able to support subtable level
caching, XML data caching and caching of execution results
of web services.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
what are windows services?
I have 3 overloaded constructors in my class. In order to avoid making instance of the class do I need to make all constructors to private?
How do you achieve polymorphism in c#?
C# Code for How to set readonly property to Id(database) value?
What is icollection in c#?
Does c# provide copy constructor?
What is an argument in c#?
Can mvc be used for desktop applications?
Are c# strings immutable?
Explain hash table in c# ?
Is c# a backend language?
Which is better javascript or c#?