| From: | "Henry Ortega" <juandelacruz(at)gmail(dot)com> |
|---|---|
| To: | "Richard Broersma Jr" <rabroersma(at)yahoo(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Best way to do this query.. |
| Date: | 2006-08-25 20:43:44 |
| Message-ID: | 2bffcc330608251343r67a73ab6x51fde94cc74dbdd4@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Yes the data does not change once it is logged.
I am quite new to this whole thing, do you mind elaborating more
about the OLAP data model you mentioned about?
On 8/25/06, Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
>
> I would assume that your data does not change after it is logged. If this
> is the case, maybe this
> part of your data model would actually be a good canidate for an OLAP data
> model.
>
> If this is not the direction your are enterested in moving, you could
> also reduce your query
> processing time by limiting the data ranges for your existing query to
> something for reasonable.
>
> Regards,
>
> Richard Broersma Jr.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-08-25 22:59:17 | Re: Best way to do this query.. |
| Previous Message | Richard Broersma Jr | 2006-08-25 20:40:56 | Re: Best way to do this query.. |