Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Local view works VERY slowly
Message
De
15/04/1998 16:44:19
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Local view works VERY slowly
Divers
Thread ID:
00092293
Message ID:
00092293
Vues:
58
I am using a grid based on local view.
Local view is based on table having many records and returns all the records.
Prb: Local view creation scans ALL the records from base table and
this works VERY slowly! So it is not possible to use local views
for large data manipulation!? Fetchsize works for remote views only.

If I use table-based grid instead of view, it appears immediately,
if there are many records returned from table. But when filter condition returns only a few rows, table-based grid causes FoxPro to
hang, but browse command works. Since there are many different queries, I cannot pre-build a index for table.
So it is not possible to use table-based grid also!

So, it is not possible to use grid control at all for large data manipulation!
Andrus
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform