[SERVER-23149] Query option to bypass cache Created: 15/Mar/16  Updated: 05/Apr/17  Resolved: 29/Sep/16

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Fabrizio Schmidt Assignee: David Storch
Resolution: Won't Fix Votes: 2
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

As there are a lot of different demands for queries like analytics adhoc requests or similar it would be very helpful to have a query option to avoid polluting the cache with results that are potentially never used for live traffic



 Comments   
Comment by David Storch [ 29/Sep/16 ]

fabrizio, I'm closing this ticket as Won't Fix, since we need more information in order to understand this feature request. If you are still interested, please re-open with further information about your use case and the proposed semantics of the new query option.

Comment by Ian Whalen (Inactive) [ 20/Sep/16 ]

fabrizio, could you clarify what problem you're running into:

  • First, is the "cache" you're referring to the plan cache? And if so are you concerned about resource consumption due to the size of the cache?
  • Or is the planner failing to evict a bad cache entry or otherwise choosing the wrong plan?
Generated at Thu Feb 08 04:02:32 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.