Thanks, but that's strange, I don't know where I read it that views could be
a problem when updating data....

Anyway, nevermind :-)))

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, March 30, 2004 10:38 PM
Subject: RE: [firebird-support] Views / performance


> > 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
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>