HQ Connections

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

Reply to
Jim
Loading thread data ...

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

Reply to
Glenn Adams [MVP - Retail Mgmt]

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...

Reply to
Jim

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. >

Reply to
Jeff

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. >

Reply to
Butch

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. >

Reply to
Jeff

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. >

Reply to
Butch

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.