Subject | Stored Procedure in Views |
---|---|
Author | Sándor Tamás |
Post date | 2011-01-24T15:59:21Z |
Hi,
It's a great thing to have selectable SPs in Views, but I have a problem.
According to my tests, is it true that if a view consists a selectable
SP and not on a simple SQL, it always executes that SP? Because I
realized that if I make an update on that view (through an update
trigger), it takes as much time as the original SP to run.
Before you say that, the trigger simply runs another SP, which takes
some milliseconds to run, so it can't be the problem.
Am I right that if a view gets it's datas from an SP, it runs it every
time something changes?
Thanks,
SanTa
[Non-text portions of this message have been removed]
It's a great thing to have selectable SPs in Views, but I have a problem.
According to my tests, is it true that if a view consists a selectable
SP and not on a simple SQL, it always executes that SP? Because I
realized that if I make an update on that view (through an update
trigger), it takes as much time as the original SP to run.
Before you say that, the trigger simply runs another SP, which takes
some milliseconds to run, so it can't be the problem.
Am I right that if a view gets it's datas from an SP, it runs it every
time something changes?
Thanks,
SanTa
[Non-text portions of this message have been removed]