On Fri, 5 Mar 2004 07:58:15 -0600, in cf-talk you wrote:
- Original Message -
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
Well, it never happened with 5.0, so while Oracle might be caching the view
somehow, I don't think it's the only issue.
- Original Message -
From: Ben Doom
I suspect that it's not CF -- it's the DB caching the view.Views are
stored optimized queries, basically, so they would contain
- Original Message -
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
Hey All,
So, I've discovered that CF seems to be caching queries whether or not I
want it to. So, for instance, I have a query like so:
SELECT*
FROMY
If Y is a view and I change the view to add a new column, I have to add
something like
WHERE 1=1
to force it to see the new view.
If I take the
, 2004 5:08 PM
To: CF-Talk
Subject: cached views
Hey All,
So, I've discovered that CF seems to be caching queries whether or not I
want it to. So, for instance, I have a query like so:
SELECT*
FROMY
If Y is a view and I change the view to add a new column, I have to add
something like
WHERE 1=1
I suspect that it's not CF -- it's the DB caching the view.Views are
stored optimized queries, basically, so they would contain column
information.The optimization includes keeping a stored list rather
than detecting all columns every time.
--Ben Doom
Deanna Schneider wrote:
Hey All,
So,
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.
However, if you don't want to go
7 matches
Mail list logo