Caching at the database level

Databases are quite a complex piece of software. Not only do they store our data efficiently, they provide us with mechanisms to retrieve that data with the same efficiency as well. This involves quite a lot of complex logic going on behind the scenes.

One of the advantages of using an ORM is the caching the database can perform at the query level. Since databases are supposed to return data in the fastest manner possible, database systems usually cache queries that are performed again and again. This caching happens at the query parsing level so that some time can be saved by not parsing the same query again and again when it is done on the database.

This kind of caching boosts response times since quite a lot of effort is saved parsing queries.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.144.255.87