Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ah, The Power of Rushmore
Message
De
17/08/2001 17:22:49
 
 
À
17/08/2001 09:48:51
Stan Vaninger
Mitek Industries, Inc
Missouri, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00545275
Message ID:
00545708
Vues:
14
If you keep in mind that reports CAN ALWAYS BE GENERATED IN UNDER 1 MINUTE, you will always find a way to 'tweek' your tables\code to generate them quickly. If you have other reports that take a while, try these tips:

1) Utilizing summary tables of tables which contain a lot of detail data.
2) Use separate tables that hold complex calculations that can be calculated ahead of reporting time during transaction processing (when doing data entry or data updates) rather than during batch processing (at time of report). These 'supporting' tables can then be related into and used for future reports.

Victor
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform