cyberman55
Registered User.
- Local time
- Yesterday, 22:52
- Joined
- Sep 22, 2012
- Messages
- 83
Running a split FE/BE application where the BE is on a storage server and each user has a local copy of the FE. It's a complicated app for estimating jobs with large tables. I've done what I can to minimize bloat and turned off transactions in all action queries as well as moving most SQL in code to queries. I can't induce the issue working on my development machine with the FE/BE both on my machine. Maybe I should set up a peer-to-peer network and put the BE on another machine here.
The client reports that the estimator screen is acceptably fast when first opened, but slows down considerably over time as they work with it. It eventually gets unacceptably slow and they have to exit the application and then reopen it to get back to useable speeds.
That estimator form has four subforms and the code refers to them when doing calculations. I tried late binding, but so much is going on during opening and during on_current events that I couldn't initially successfully do late binding. In any event (no pun), they have not reported any slowdown loading the form, just when they try to perform actions via buttons and combo boxes on the form(s).
I noticed a thread where Pat Hartman suggested each user having their own copy of the FE on the server in individual folders. Would moving the front ends to the same server as the back end help? Other thoughts?
The client reports that the estimator screen is acceptably fast when first opened, but slows down considerably over time as they work with it. It eventually gets unacceptably slow and they have to exit the application and then reopen it to get back to useable speeds.
That estimator form has four subforms and the code refers to them when doing calculations. I tried late binding, but so much is going on during opening and during on_current events that I couldn't initially successfully do late binding. In any event (no pun), they have not reported any slowdown loading the form, just when they try to perform actions via buttons and combo boxes on the form(s).
I noticed a thread where Pat Hartman suggested each user having their own copy of the FE on the server in individual folders. Would moving the front ends to the same server as the back end help? Other thoughts?