dengolding
asked on
Slow access on Domain
I have a problem with slow access on a remote server. I am also permitted no access and given no information by the defence department to solve the problem. First of all the system is slow anyway because of bandwidth. Previously, my VO application which uses foxpro (.dbf) files worked fine with several users under workgroups on a local file server. Now they've created a domain and put the data on a remote server with the .exe and .dll files on the local C: drive (which is hidden).
For the first user to access the files and produce a report, the speed is reasonably fast, but if they stay with the databases open and a second user runs the same report, the second user runs very slowly - up to 10 minutes instead of 3-4 seconds. This didn't happen under workgroups local server.
Does anyone have an idea why this happens please.
For the first user to access the files and produce a report, the speed is reasonably fast, but if they stay with the databases open and a second user runs the same report, the second user runs very slowly - up to 10 minutes instead of 3-4 seconds. This didn't happen under workgroups local server.
Does anyone have an idea why this happens please.
Are you really talking about a remote domain here? Is it only connected via vpn connection, or is it still a local areea network? What is the bandwidth and ping time? To turn off oplocks is a candidate for a solution, but also the nature of dbf access needs more roundtrips from requesting a dbf to be opened and data to "stream" to the clients, than a real server database. That's making such VPN solutions a slow thing compared to LAN access, even with similar bandwidths.
Ping time, which about is the time for some minimalisitc request ("ping") to get to the destination and back is about: <1 ms for LAN, ~50ms for a server in the same country, at least as a rough value. It strongly depends. But it's this latency time which plays a bigger role, than just the bandwidth.
Bye, Olaf.
Ping time, which about is the time for some minimalisitc request ("ping") to get to the destination and back is about: <1 ms for LAN, ~50ms for a server in the same country, at least as a rough value. It strongly depends. But it's this latency time which plays a bigger role, than just the bandwidth.
Bye, Olaf.
ASKER
Olaf, the server is on a 'server farm' somewhere in the middle of the UK and accessed by all points coast to coast. I have no access to it as it's a secure locked down system managed by an external agency for the government.
Everything I do is by guesswork so I'll send them the note about oplocks and see if anyone responds. My software is nation wide but they are very slow to do anything. Meanwhile my clients are going crazy.
Everything I do is by guesswork so I'll send them the note about oplocks and see if anyone responds. My software is nation wide but they are very slow to do anything. Meanwhile my clients are going crazy.
Well, rereading your outset, I get confused more and more: "data on a remote server with the .exe and .dll files on the local C: drive (which is hidden).
What do you really mean by that? data is remote, exe and runtime is local? How does a hidden C: drive match to this specification? Or is both data AND exe+runtimes on a remote server or remote lan? Do users use your software via remote pc, terminal services? Do they have an installation of your exe on their pc and only data is remote? What is really where?
Bye, Olaf.
What do you really mean by that? data is remote, exe and runtime is local? How does a hidden C: drive match to this specification? Or is both data AND exe+runtimes on a remote server or remote lan? Do users use your software via remote pc, terminal services? Do they have an installation of your exe on their pc and only data is remote? What is really where?
Bye, Olaf.
ASKER
The company that is used by this government organisation has packaged up all the software so that each user will download all software they have permission for to any terminal (pc) they log in to. It is loaded to the C: drive which is hidden to the user in 'my computer', but of course a shortcut can be made to boot the software. Presumably they did this to stop users playing with files on the C: drive.
The company has located the data files which my programme uses, on a server in the middle of the country together with data for all the other apps. They have not revealed the method of communication but I assume they use an intranet.
I hope this makes things clearer, but it is difficult when they are paranoid about security and and give us little or no information.
The company has located the data files which my programme uses, on a server in the middle of the country together with data for all the other apps. They have not revealed the method of communication but I assume they use an intranet.
I hope this makes things clearer, but it is difficult when they are paranoid about security and and give us little or no information.
I've requested that this question be deleted for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It is hard to help if the proven solution (switching SMB2 and oplocks off) cannot be implemented...
ASKER
Hello,
Sorry I disappeared for a while. A failing hard drive on my laptop has set me back and taken days to recover. I have submitted the suggestions shown here to Atos who is the company employed by the government to run their computer systems. I can't tell you which dept but there's no secret. As yet they have not responded to any of my emails but I understand they have escalated the problem up a few levels, whatever that means. So, I'm working totally in the dark with no access to their system and no communication from them but the users are reporting this slowness all the time.
I'm sure they can impliment your suggestion pcelba but they keep quiet so I don't know if they have or have not or just haven't a clue.
I don't know how to progress this question now but will email all concerned again to see if they are taking any notice and report back. If however you feel the question should be closed then please tell me how I can report the solution when it's finally resolved.
Sorry I disappeared for a while. A failing hard drive on my laptop has set me back and taken days to recover. I have submitted the suggestions shown here to Atos who is the company employed by the government to run their computer systems. I can't tell you which dept but there's no secret. As yet they have not responded to any of my emails but I understand they have escalated the problem up a few levels, whatever that means. So, I'm working totally in the dark with no access to their system and no communication from them but the users are reporting this slowness all the time.
I'm sure they can impliment your suggestion pcelba but they keep quiet so I don't know if they have or have not or just haven't a clue.
I don't know how to progress this question now but will email all concerned again to see if they are taking any notice and report back. If however you feel the question should be closed then please tell me how I can report the solution when it's finally resolved.
ASKER
Please see my last posting and decide from there.
I've requested that this question be deleted for the following reason:
Unfortunately, as the comments were not implemented, theres no way to know whether the information was good enough to solve the problem in THIS case. We only want VERIFIED solutions in the PAQ database. <br /><br />Restarting the Auto Delete process to finalize. <br /><br />Thanks, <br /><br />JustAMod <br />CS Moderator
Unfortunately, as the comments were not implemented, theres no way to know whether the information was good enough to solve the problem in THIS case. We only want VERIFIED solutions in the PAQ database. <br /><br />Restarting the Auto Delete process to finalize. <br /><br />Thanks, <br /><br />JustAMod <br />CS Moderator
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
We don't need points but the solution should remain in the database.
Please mark the ID:37175895 as the answer.
Please mark the ID:37175895 as the answer.
If you don't like this solution in Windows OS zones then you may remove Windows zones and leave the question in FoxPro zone only.
Following links could tell more:
http://fox.wikis.com/wc.dll?Wiki~OpportunisticLocking
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html
http://www.alaska-software.com/fixes/smb2/overview.shtm
http://social.msdn.microsoft.com/Forums/de-DE/foxprode/thread/8e21c105-da19-4ac5-847c-1169962c0826