Re: Store derived data or use view?

If it's static (i.e. the planets don't move too much, hah), calculate
and store. No sense in re-calculating it each and every time.


Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549-6666 x4294

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of gvimrc
> Sent: Friday, July 03, 2009 1:08 PM
> To: pgsql
> Subject: [GENERAL] Store derived data or use view?
>
> I have a table which stores the absolute longitude of a planetary
> position, eg:
>
> MERCURY
> ---------------
> 157.65
>
> SATURN
> -------------
> 247.65
>
> When 2 planets are a certain distance apart there is an 'aspect', eg.
90
> degrees is a "square" aspect
>
> I wish to record these aspects for different user profiles and
eventually
> do searches for users who have the same aspect(s). Would it be better,
in
> terms of search speed/efficiency, to calculate and store the aspect
data,
> eg. Mercury/Saturn square, or should I just store the longitude data
and
> create a view with the calculated aspects? I anticipate a large
dataset of
> users so search speed/efficiency is very important.
>
> gvim
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general.now.