Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Nigel,
One more tip:
If RI or stored procedures are used in the large table, make sure that the related tables are already open in another workarea. This shortens the time needed to run the stored procs or RI code dramaticly, because:
- Every time a record is insterted one or more related tables have to be opened and closed. If the table is already opened in another workarea, it shortens the time needed to open the table (because of loading buffers).
- It reduces network trafic because if you don't have the tables already open, it has to load the buffers from the server for every table on every record which is replace or inserted.
peformance gains between 100% and 300% are possible. (I never tested this on slow networks)
Walter,
Précédent
Suivant
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