Is there a way to speed up the connection time between SO and HQ? Maybe select specific data to upload, rather than uploading all data. I have 35 stores connecting to HQ with a need for real time reporting. So my current configuration consists of a store connecting every 3 to 4 minutes over two hours, and I am getting allot of Deadlock errors or the HQ queue fills and some store won't even synch. Any comments or helpful hints are greatly appreciated, Jim
HQ Connections
Oct 12, 2006
6 Replies
What RMS version are you on? 1.3 improved the connection performance over 1.2, but I think you are still trying to get too much. It's possible to run multiple instances of HQ Server, but you still might run into deadlocks at the DB level.
Glenn Adams Tiber Creek C> Is there a way to speed up the connection time between SO and HQ? Maybe
Hello Glenn, I'm running 1.3 and I did not see any improvment on the connection speed. I am running two diffrent instances of HQ on one server with 8 processors, I have not peak my bandwidth from my stores or from my HQ box. I starting to run out of options, so I'm thinking of attacking it from the DB side, if I can cut down the amout on information then I would then speed up my connection. Any ideas? Jim
"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:u$ snipped-for-privacy@TK2MSFTNGP02.phx.gbl...
Hello Glenn, I'm running 1.3 and I did not see any improvment on the connection speed. I am running two diffrent instances of HQ on one server with 8 processors, I have not peak my bandwidth from my stores or from my HQ box. I starting to run out of options, so I'm thinking of attacking it from the DB side, if I can cut down the amout on information then I would then speed up my connection. Any ideas? Jim
"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:u$ snipped-for-privacy@TK2MSFTNGP02.phx.gbl... > What RMS version are you on? 1.3 improved the connection performance over > 1.2, but I think you are still trying to get too much. It's possible to > run multiple instances of HQ Server, but you still might run into > deadlocks at the DB level. >
Hello Glenn, I'm running 1.3 and I did not see any improvment on the connection speed. I am running two diffrent instances of HQ on one server with 8 processors, I have not peak my bandwidth from my stores or from my HQ box. I starting to run out of options, so I'm thinking of attacking it from the DB side, if I can cut down the amout on information then I would then speed up my connection. Any ideas? Jim
"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:u$ snipped-for-privacy@TK2MSFTNGP02.phx.gbl... > What RMS version are you on? 1.3 improved the connection performance over > 1.2, but I think you are still trying to get too much. It's possible to > run multiple instances of HQ Server, but you still might run into > deadlocks at the DB level. >
Hello Glenn, I'm running 1.3 and I did not see any improvment on the connection speed. I am running two diffrent instances of HQ on one server with 8 processors, I have not peak my bandwidth from my stores or from my HQ box. I starting to run out of options, so I'm thinking of attacking it from the DB side, if I can cut down the amout on information then I would then speed up my connection. Any ideas? Jim
"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:u$ snipped-for-privacy@TK2MSFTNGP02.phx.gbl... > What RMS version are you on? 1.3 improved the connection performance over > 1.2, but I think you are still trying to get too much. It's possible to > run multiple instances of HQ Server, but you still might run into > deadlocks at the DB level. >
Hello Glenn, I'm running 1.3 and I did not see any improvment on the connection speed. I am running two diffrent instances of HQ on one server with 8 processors, I have not peak my bandwidth from my stores or from my HQ box. I starting to run out of options, so I'm thinking of attacking it from the DB side, if I can cut down the amout on information then I would then speed up my connection. Any ideas? Jim
"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:u$ snipped-for-privacy@TK2MSFTNGP02.phx.gbl... > What RMS version are you on? 1.3 improved the connection performance over > 1.2, but I think you are still trying to get too much. It's possible to > run multiple instances of HQ Server, but you still might run into > deadlocks at the DB level. >
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required