Optimizing Report Builder


(system) #1
Wayne,

I have noticed that on some of the more complex reports the way you enter
filters v=can have a major impact on speed and the information actually
returned.

Eric Tolliver
IT\MIS
Continental Industries Inc.
5456 E. Mcdowell Rd.
Mesa, Az 85215
http://ciirelays.com/
mailto:e.tolliver@...

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Monday, August 07, 2000 8:38 AM
To: vantage@egroups.com
Subject: [Vantage] Optimizing Report Builder

Does anyone know if the Progress Report Builder and / or Database engine
automatically optimizes report functions, such as selection and sorting?

Eg: is there any benefit to trying to arrange my filters with most
selective first, indexed fields first, etc? I'm trying to write up some
standards and suggestions for the people using Report Builder; but with
only 7 mos of data accumulated, everything runs almost instantly anyway.

-Thanks,
Wayne

(system) #2
Does anyone know if the Progress Report Builder and / or Database engine
automatically optimizes report functions, such as selection and sorting?

Eg: is there any benefit to trying to arrange my filters with most
selective first, indexed fields first, etc? I'm trying to write up some
standards and suggestions for the people using Report Builder; but with
only 7 mos of data accumulated, everything runs almost instantly anyway.

-Thanks,
Wayne