Subject | Views / performance |
---|---|
Author | Nico Callewaert |
Post date | 2004-03-30T20:29:27Z |
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
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