christakis
Registered User.
- Local time
- Today, 22:46
- Joined
- Oct 23, 2009
- Messages
- 72
I created a FE/BE database, the FE runs very fast at out local office but extremely slow from our other office. Its around 300 miles away. I don't think its a bandwidth problem as when we send large files between the two sites its rocket fast. Note that the network between sites is an intranet not an internet.
I've looked this up before posting. People suggest to have a ghost table to keep the FE/BE connection live. My main menu queries the BE to populate a listbox so I suspect the connection is active. It appears that the less data the FE retrieves the slower it is. For example, a simple query to populate a combobox takes around 15 sec. A query to filter 100s or records takes around 5 seconds to complete. The lag is unacceptable. Waiting for 30 sec for a form to open is a nono.
I am even wondering if the intranet traffics network. What protocol does the database use to communicate FE with BE? Is there a chance the firewall has something to do with it?
It is so bad I am thinking of having two back ends (one at each site) and synchronizing them. Do you have any other suggestions?
I've looked this up before posting. People suggest to have a ghost table to keep the FE/BE connection live. My main menu queries the BE to populate a listbox so I suspect the connection is active. It appears that the less data the FE retrieves the slower it is. For example, a simple query to populate a combobox takes around 15 sec. A query to filter 100s or records takes around 5 seconds to complete. The lag is unacceptable. Waiting for 30 sec for a form to open is a nono.
I am even wondering if the intranet traffics network. What protocol does the database use to communicate FE with BE? Is there a chance the firewall has something to do with it?
It is so bad I am thinking of having two back ends (one at each site) and synchronizing them. Do you have any other suggestions?