Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updateable views are too slow
Message
De
31/05/2002 21:13:36
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, États-Unis
 
 
À
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:
00663749
Vues:
25
Hi Carlos,
What indexes are on the source table of the view? Do they allow the update to be rushmorizable?


>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 ?
Charlie
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform