Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View Performance Stinks
Message
De
28/04/1998 16:25:06
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Remote View Performance Stinks
Divers
Thread ID:
00095519
Message ID:
00095519
Vues:
47
I need some ideas on how to improve my application's performance in retrieving data via remote views.

Here's the problem:
If I open just one form, performance ( data retrieval from Access MDB files and screen redraws ) is acceptable. If I open a second form, not a second instantiation of the same form, but a separate form, it takes several minutes for the form to load and I sit drumming my fingers waiting minutes for operations that occure virtually instantly when just one form is open. Each form is set to have a private data session. Each form, aka CodeBook, doesn't use the default dataenvironment but a dataenvironment instantiated this way - MyForm.oDE = CREATEOBJECT( customDataEnvironment )

If you have some ideas, whether it be configuration of the ODBC connection or whatever, I'm open to them. As is, I've got to come up with something better.

BTW I'm building the client half of a client/server application. Rather than take the time to build Fox Pro copies of their current tables and develop the application against them. I've chosen to run the application against copies of their existing tables, which are Access 97 MDB files, using ODBC and remote views. My "development" network is a peer-peer 10T ethernet network between my desktop, running NT4 Workstation and my notebook running Win95.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform