Query caching on table level

[eluser]TheFuzzy0ne[/eluser]
Hello.

I'm not sure I agree with your "perfect scenario". It would mean that you would have put the table names in your query in the exact same order (unless your cacher put the table names in alphabetical order).

Is there any reason why you can't have your model clear the cache for a particular query when new data is inserted? I wouldn't have thought it would be too difficult to achieve.