| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lew | 2010-03-21 19:59:41 | Re: DESIGN OF A SELECT QUERY |
| Previous Message | Daniel Staal | 2010-03-21 01:55:22 | Re: Speed question - new view using preview view components |