Subject | RE: [firebird-support] Views / performance |
---|---|
Author | Alan McDonald |
Post date | 2004-03-30T20:38:25Z |
> Hi,A view is merely a stored SQL statement which is fired on the data when you
>
> I've read that too many views is not good for the performance,
> because on every insert / edit / delete, te pointers on the view has to be
> updated, right ? (Correct me if I'm wrong). Is that the same thing with
> other databases like SQL server ? I mean is the system of views
> the same on
> all engines ?
> So, in Firebird, is it the best to avoid too many views ?
>
> Thanks in advance, Nico Callewaert
>
request the view.
I can't see how too many views would alter performance.
There are no pointers being updated as you say.
Alan