Re: Views- Advantages and Disadvantages - Mailing list pgsql-general

From Ragnar
Subject Re: Views- Advantages and Disadvantages
Date
Msg-id 1178701529.10736.54.camel@localhost.localdomain
Whole thread Raw
In response to Re: Views- Advantages and Disadvantages  ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
List pgsql-general
On mið, 2007-05-09 at 12:46 +0530, Ashish Karalkar wrote:

> I have found out some of them n are as follows, but  I want more reasons
> for not using views . I only got one

>
>  Disadvantages:

> 1)      Performance : If a view is defined by complex multitable query,then
> simple query against that view becomes a coplecated join, and it may take a
> long time to complete
>

2) UPDATES on a view are more tricky.

gnari



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: PG on Debian 4.0.x ?
Next
From: Ron Johnson
Date:
Subject: Re: Views- Advantages and Disadvantages