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
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
