pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
view and performance
2+ messages / 2 participants
[nested] [flat]

* view and performance
@ 2001-07-06 18:38  Wei Weng <wweng@kencast.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Wei Weng @ 2001-07-06 18:38 UTC (permalink / raw)
  To: pgsql-sql

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?

Thanks!

-- 
Wei Weng
Network Software Engineer
KenCast Inc.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: view and performance
@ 2001-07-07 11:25  Richard Huxton <dev@archonet.com>
  parent: Wei Weng <wweng@kencast.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2001-07-07 11:25 UTC (permalink / raw)
  To: Wei Weng <wweng@kencast.com>; pgsql-sql

From: "Wei Weng" <wweng@kencast.com>

> 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-07-07 11:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-06 18:38 view and performance Wei Weng <wweng@kencast.com>
2001-07-07 11:25 ` Richard Huxton <dev@archonet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox