Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Q:View/Table as a cursorsource? - part 2
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Q:View/Table as a cursorsource? - part 2
Divers
Thread ID:
00247260
Message ID:
00247260
Vues:
54
Hi folks,

After new tests I realized that I can remarkably reduce the time tableupdate() takes, if I create an index into the same field of underlaying table what has been defined as a key field in the view. Even though there's is still a small delay in data processing, it's only a fraction comparing to the earlier situation.

So, saving seems to be allright now, but how to improve the fetching time of data? Indexes don't help here, do they?

Regards,
Ilkka
Ilkka Koskinen
Tel : +358 40 729 3530
Fax : +358 9 3920 7210
Email: Ilkka.Koskinen@tietoenator.com
Répondre
Fil
Voir

Click here to load this message in the networking platform