From: "Jamie Jackson"
> I don't know if this is related, but if I've got a view (using *) that
> depends on other views, and I alter a sub-view, I get column caching
> even directly within enterprise manager. I put a utility in my app to
> call a "view cache"-clearing sproc to rememedy this.
Hm... These views do depend on sub-views. But, the views themselves aren't
using *, just the cf queries calling the views. I'd still be interested in
your view cache-clearing sproc, though.
> However, if you don't want to go that far, and you aren't doing query
> caching, maybe you could do something like this to guarantee
> freshness? (This is based on your own workaround.)
>
> blah = createUUID(); // or gettickcount(), or something
>
> SELECT *
> FROM Y
> WHERE '#blah#' = '#blah#'
>
It's really just a pain in development, and re-cycling the cf server also
seems to take care of it. I don't _think_ it's caching the data of the view,
at least that's how it appears with some brief testing. So, once the view is
solid and it goes into production, I should be home-free.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
