×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ERP uses PSQL DB and functions slowly via VPN

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?

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

It's been years but I've run the PSQL engine through a VPN and don't remember any specific problems. If you load the Pervasive Control Center and run a query or Function Executor and open a data file and read several records, does it work at a normal rate?
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

(OP)
Thanks for the reply Mirtheil. I try to keep our VPN ports locked down to the basics needed by whatever app is running through that specific tunnel so I am going to go back and check to make sure all of those ports are open for business. I will try using PCC and see if it is more responsive that through the ERP app, havent tried that yet.

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

(OP)
Calls via PCC are also slow. So it isnt just the ERP software but all of Pervasive. Checking more in depth with our VPN tunnel.

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

You're likely to find more benefit in setting up an RDP server and then have your client machines connect to the VPN and then RDP to that server. That way your ERP system is running 'locally' on the RDP server and your end-users should have a relatively speedy experience.

RE: ERP uses PSQL DB and functions slowly via VPN

(OP)
So that is how we have it set up now, via a VPN connection and a RDP session. We are playing again with RDweb which somehow seems more responsive even though I know it is basically the same as an RDP session.

Learning - A never ending quest for knowledge usually attained by being thrown in a situation and told to fix it NOW.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close