Subject RE: [firebird-support] Views / performance
Author Alan McDonald
> Hi,
>
> 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
>

A view is merely a stored SQL statement which is fired on the data when you
request the view.
I can't see how too many views would alter performance.
There are no pointers being updated as you say.
Alan