Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement