what you really need to do is optimize the SQL processing on A,B,C so they
don't put an inordinate load on the system, select from D will take care of
itself
what's that processing look like?
- mcs
>
> I'll explain it a little more :)
>
> The tables A,B,C saves raw data, which is periodically processed (say,
every
> hour). The calculations done (counts, joins, "correlations", etc), produce
a
> small set of results, which is stored in the D table. This final table may
> be accessed for viewing the results, and I would like the select
operations
> in this results table to be of a higher priority, so the "user experience"
> is better. The results being calculated may take longer to be produced,
but
> the current results should be returned as fast as possible.
>
> I'm a poor programmer :p who must face this beast (Oracle), so I thought
> that perhaps there was a way to do what I had in mind. I have somewhat
> optimized the SQL, but I was wondering if it was possible to apply this
> "priority" principle.
>
> Thanks again.
>
>
Received on Thu Nov 06 2003 - 09:46:18 CST