Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updateable views are too slow
Message
De
31/05/2002 19:02:19
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
31/05/2002 16:24:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00663659
Message ID:
00663722
Vues:
19
>I have at this moment a table with 4 fields , two of them are key fields. This table contains information about questionaries identified by an internal counter. I'm using an updateable local view but it is getting too slow when the update is made taking about 10 seconds in a PII 233Mhz PC - it has about 100,000 records at this moment.
>
>Does anyone know what can be done ?

Perhaps this will get faster if you update on key fields only. See the update page of the view designer.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform