Skip site navigation (1) Skip section navigation (2)

Re: Speed question - new view using preview view components

From: Van Ly <van_ly(at)ovi(dot)com>
To: rterry(at)pacific(dot)net(dot)au
Cc: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Speed question - new view using preview view components
Date: 2010-03-21 02:12:15
Message-ID: 2C85A1A8-232E-47AE-95A6-3780666C0D9D@ovi.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 21/03/2010, at 12:23 PM, richard terry wrote:

> I wondered if when creating a new view from multiple tables, and then also 
> joining to some fields of an existing view, if one pays much of a speed 
> penalty when the data is retrieved, as opposed to just completely using all 
> tables.


It is possible to measure the time of performance. In one way I know, you
could put the sql select call in a script for each of the two
situations and on a unix-like platform call for	timings	with

time sh situation0.sh
time sh situation1.sh

Best wishes.

Van Ly
van_ly(at)ovi(dot)com




--------------------------------------------------------------
Ovi Store: New apps daily
http://store.ovi.com/?cid=ovistore-fw-bac-na-acq-na-ovimail-g0-na-3


In response to

pgsql-novice by date

Next:From: LewDate: 2010-03-21 19:59:41
Subject: Re: DESIGN OF A SELECT QUERY
Previous:From: Daniel StaalDate: 2010-03-21 01:55:22
Subject: Re: Speed question - new view using preview view components

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group