use_cached_result

[angel_ba]

i am trying to execute same query on 3 different platforms - dbeaver, python notebook and sql workflow.I was expecting after first execution of the query irrespective of the platform, subsequent execution of same query should NOT re-compute. However each platform behaves independently. I assume use_cached_result = true by default. How can I use the results of the query executed once across all the platforms

[Kaniz · Accepted solution]

Hi @bhawana, One possible solution is to use a caching layer in front of your database, such as Memcached or SafePeak. These tools can store the query results in a distributed memory cache and allow you to access them from multiple platforms. This way, you can avoid hitting the database directly for each query and reduce the load on your database server.

Another possible solution is to use a temporary table or a view in your database to store the query results. You can then join this table or view it with other tables or views in your queries and avoid repeating the same query. This way, you can leverage the indexes and statistics of your database to optimize your queries.

You can find more information about these solutions :

• Caching result of SELECT statement for reuse in multiple queries
• SQL SERVER - Performance: Do-it-Yourself Caching with Memcached vs. Automated Caching with SafePeak
• Understanding ResultSet Caching in Dedicated SQL Pools … - Serverless SQL
• How to cache resulting dataframe from sql query

I hope this helps you with your problem. Please let me know if you have any other questions or feedback. 😊

[Kaniz]

I want to express my gratitude for your effort in selecting the most suitable solution. It's great to hear that your query has been successfully resolved. Thank you for your contribution.