Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f67BXPa27546 for ; Sat, 7 Jul 2001 07:33:25 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-30.mail.demon.net with esmtp (Exim 2.12 #1) id 15IqMj-0006Mq-0U; Sat, 7 Jul 2001 12:35:14 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 0F40714408; Sat, 7 Jul 2001 12:25:38 +0100 (BST) Message-ID: <007a01c106d7$8b57b1c0$1001a8c0@archonet.com> From: "Richard Huxton" To: "Wei Weng" , References: <994444708.16303.3.camel@Monet> Subject: Re: view and performance Date: Sat, 7 Jul 2001 12:25:34 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200107/82 X-Sequence-Number: 3866 From: "Wei Weng" > Is there any gain on performance if you choose to create a view over a > very complex query instead of running the query itself directly? I *believe* views are pre-parsed so you gain that time. Can't believe you'd notice much difference either way unless the query was very fast to execute. - Richard Huxton