Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best Practices in Fetching Recs for a C/S DataEntry Form
Message
De
23/07/2010 23:00:43
 
 
À
23/07/2010 22:50:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Divers
Thread ID:
01473556
Message ID:
01473672
Vues:
43
Craig,

Thanks for your ideas sir. They are valuable.

Currently, I still use one single Data Entry Form class - whether it be DBF tables or DE class with CA cursors. So, for my DE Class, it loads up the entire table from, say, the INVOICES table! Speed was pretty good initially, but when the app's Invoice records reached 100,000s, it now takes quite a few seconds of time to load up the data entry form. Hence, this thread.

Initially, my idea was to get the records in batches of X rows - akin to how web pages do it.

But, thanks to your advise, I will be refactoring my classes in that direction.

Dennis
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform