Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>My question is this: Instead of filtering the data according to the teacher code (i.e. SET FILTER TO TCODE = XXX) would the application perform faster if I re-engineered the application to use views instead.
>
>If the performance improvement were drastic, then I certainly would rewrite. However, if the performance improvement would be negligible, then I would prefer to keep things the way they are.
>
>Disregarding issues concerning locking, etc, I mainly am interested if I can expect a VIEW to be very much faster than issuing a SET FILTER.
>
>I appreciate and welcome any input...
Hi Patric
From my recent experience, you should at least try out Cetin's suggestion to use SET KEY. You can use filters as well, if needs be. Just remember that if you change the order, you need to change the set key statement to match.
If you have slow networks, the less traffic across the wire, the better will be the performance.
You will find it requires very little change to your code. Switching to SET KEY in one instance reduced the load time from over 70 seconds to about 6-7, including the time to instantiate the form, and has dramatically improved performance wherever I used it.
Geoff
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