General information
Title:
Remote View Performance Stinks
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only