> Various queries can have the same condition but different parameters (e.g., showing it in a table vs. showing it in a list).We should only have one cache for two queries that have the same results.
Fully agree with this. I'm proposing to cache the result of a queries, not the visualizations of them. So the cache key would consist of the conditions, the printouts, offset, limit, sort, and perhaps some other relevant parameter I'm forgetting.
> We can still have a query table (it would be interesting to store
information about individual queries beyond the condition they have).
You need this either with this approach or the one you're arguing against no?
Jeroen De Dauw
Don't panic. Don't be evil.