Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View Performance Stinks
Message
From
28/04/1998 16:25:06
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Remote View Performance Stinks
Miscellaneous
Thread ID:
00095519
Message ID:
00095519
Views:
46
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.
Next
Reply
Map
View

Click here to load this message in the networking platform