ERP uses PSQL DB and functions slowly via VPN
ERP uses PSQL DB and functions slowly via VPN
(OP)
Hello All,
Our ERP system is very unique to our industry so it is almost a necessity. Switching ERP systems would be insanely cumbersome so that may not be a solution. The ERP runs off a PSQL database and works fine in house. Our remote sales reps utilize a VPN tunnel and have to RDP to an onsite terminal server to use the ERP software. If they try to use the ERP software on their local machine through the tunnel, it is very slow to display whatever info they are trying to search for or input. Local internet is fine on each remote user as well as on our end. We do not restrict the bandwidth on the VPN tunnel. My question is, do all PSQL databases run poorly through a VPN tunnel or is this particular software coded insufficiently? I know of multiple companies that run their database programs through a VPN tunnel and do not seem to have this issue. Granted most of those I am familiar with are SQL dbs, not sure if that makes much difference.
Any thoughts?
Our ERP system is very unique to our industry so it is almost a necessity. Switching ERP systems would be insanely cumbersome so that may not be a solution. The ERP runs off a PSQL database and works fine in house. Our remote sales reps utilize a VPN tunnel and have to RDP to an onsite terminal server to use the ERP software. If they try to use the ERP software on their local machine through the tunnel, it is very slow to display whatever info they are trying to search for or input. Local internet is fine on each remote user as well as on our end. We do not restrict the bandwidth on the VPN tunnel. My question is, do all PSQL databases run poorly through a VPN tunnel or is this particular software coded insufficiently? I know of multiple companies that run their database programs through a VPN tunnel and do not seem to have this issue. Granted most of those I am familiar with are SQL dbs, not sure if that makes much difference.
Any thoughts?
Learning - A never ending quest for knowledge usually attained by being thrown in a situation and told to fix it NOW.
RE: ERP uses PSQL DB and functions slowly via VPN
Is the EXE that's displaying the data loading from the remote server or local machine?
PSQL uses standard TCP/IP for communicating through ports 1583 (ODBC), 3351 (Btrieve), and 3352 (Scalable SQL - very old).
Mirtheil
http://www.mirtheil.com
RE: ERP uses PSQL DB and functions slowly via VPN
Learning - A never ending quest for knowledge usually attained by being thrown in a situation and told to fix it NOW.
RE: ERP uses PSQL DB and functions slowly via VPN
Learning - A never ending quest for knowledge usually attained by being thrown in a situation and told to fix it NOW.
RE: ERP uses PSQL DB and functions slowly via VPN
RE: ERP uses PSQL DB and functions slowly via VPN
Learning - A never ending quest for knowledge usually attained by being thrown in a situation and told to fix it NOW.