Bug in view/edit view ?

[olof]

Hi,

when I try to view or edit a view (not all, just one), I have to wait some minutes before the text of the view appears.

In the user_views view, I can see the text instantaneously.

Any idea ?

Thanks !

 

[amaury]

user_views contains the text of the view, but without the list of columns. So the "edit view" command has to "describe" the view to get this list.
I guess that "select * from myview where 1=0" makes you wait as long...

Amaury

 

[Marco Kalter]

This can take a long time if any of the referenced objects are invalidated.

------------------
Marco Kalter
Allround Automations

 

[olof]

Amaury :

Hi,

select * from where 1=0

take no long. Just one second.

mkalter :

Hi,

my view is based on one another view and 11 tables. And the view is valide !

...

 

[Marco Kalter]

I will look into this.

------------------
Marco Kalter
Allround Automations