Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2017
    Location
    Palo Alto, Ca.
    Posts
    6

    Unanswered: Caching for Sql Sever

    Hello,

    Is anyone implementing SQL caching? We have created a solution that caches SQL in the application server to avoid network latency to the database. I would love to get your experience on SQL caching.

    Thanks.

    Munchai

  2. #2
    Join Date
    Aug 2017
    Posts
    1

    SQL Cacing

    Your question is open-ended as there are lots of different types of SQL/database caching. The database itself will cache frequently used query plans and data blocks. There is nothing a user needs to do to take advantage of this. SQL Server does not cache query results however.

    My experience is that there can be a significant benefit in caching SQL query results. Many database applications execute repetitive queries that take time and add load to the database. Developers may try to cache themselves inside the application or by using grid caches such as Redis or Hazelcast. The challenge is that this requires work and determining what if anything should be cached.

    You may want to look at the product called Heimdall that does auto-caching of SQL results in applications. There is a blog on it here: https://www.codeproject.com/Articles...-with-Heimdall

    It says that it will provide analytics on the benefit of caching for an application without requiring any changes.

  3. #3
    Join Date
    Dec 2016
    Posts
    8

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •