Subject | Re: Using a View in IB_Query.SQL |
---|---|
Author | Eric Handbury |
Post date | 2002-10-16T22:18:12Z |
--- In IBObjects@y..., "Martin D. Berezaga" <mdberezaga@y...> wrote:
From what I understand...
Advantages:
1) Views don't have to be prepared. So technically they are faster
(initially).
Disadvantages:
2) Views are not updateable in certain instances.
But these are client-side issues... if all this is done within SPs,
then there would be no difference.
> Is there any vantage/disvantage on using a View instead the Jointhat forms
> the View? I'm using my own Edit/Inser/Delete SQL (StoredProcedures).
From what I understand...
Advantages:
1) Views don't have to be prepared. So technically they are faster
(initially).
Disadvantages:
2) Views are not updateable in certain instances.
But these are client-side issues... if all this is done within SPs,
then there would be no difference.