Path: utzoo!attcan!uunet!tut.cis.ohio-state.edu!ucbvax!bloom-beacon!eru!hagbard!sunic!news.funet.fi!uta!on From: on@uta.fi (Ossi Numminen) Newsgroups: comp.databases Subject: Re: Views make base table updates more slowly in INGRES? Message-ID: <1705@kielo.uta.fi> Date: 29 Oct 90 05:39:42 GMT References: <1697@kielo.uta.fi> Reply-To: on@kielo.uta.fi (Ossi Numminen) Organization: University of Tampere, Finland Lines: 23 In article bg0l+@andrew.cmu.edu (Bruce E. Golightly) writes: >That might be true, depending on what makes up the view and what objects >are associated with the base table(s). A complex view consisting of a >number of tables linked together might take a while to update. This >could be complicated by base tables with inappropriate structures or >lots of secondary >indices.I suspect, though, that there is no appreciable difference >between operating on a view and performing the same set of operations on >the corresponding set of tables. It is understandable that updating through a view takes some more time than just updating a base table directly. But if you have some views for just retrieving the information and then you update that under- lying base table directly, I see no reason why this update should take any longer than updating the same table in the case it had no views. And this is what they are claiming. > >How about more details? I'll try to get some. ---ossi