Re: Canceling a Query
| From: | John Lim | Date: | Sat, 19 May 2001 12:03:15 +0000 |
| Subject: | Re: Canceling a Query | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-7752@lists.php.net to get a copy of this message | ||
You mentioned that the results don't return many rows. So if you are using a
lot of
aggregate functions (max, min, etc), it's possible to precalculate them
every night
and join on the precalculated values. Much faster. I also believe there are
data warehousing solutions that automatically precalculate these aggregates
for you, eg. Oracle's.
Regards, john