Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed of Views Vs Tables
Message
De
30/10/2003 09:33:41
 
 
À
30/10/2003 08:52:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00844370
Message ID:
00844487
Vues:
24
Hi,
Sorry for jumping in.
I have experienced diffuculty of using local view to update records in my item promotion maintenance. This maintenance allows user to key in any items that offered discount within a given period.

The number of items in any promotion would usually exceed 200. VFP takes 10-15 seconds to save it to table. My clients always complaint about it. At the end, I got to use underlying table instead of local view. And VFP only takes 2 seconds to save it.

Do you have any workaround?

Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform