rcoltrane
I have a client-server application with an Oracle Express 10g database that works fast under my local network where the server is located. However, clients that are out of this location are using an OpenVPN tunnel in order to connect to the database and retrieve information, but the data retrieval is too slow. For example, when selecting one row into a listview which populates just a couple of fields on the screen, it takes near 5 seconds just to retrieve these few fields from the database and populate it. Locally, the same process is instantaneous. The Internet on both sides are asynchronous: on the server side, I have a 35mb download speed and 3mb upload. And on the client side, the internet has 10mb of download and 1mb of upload, but on this side, I have less users accessing the database.
Is there something I could do in OpenVPN to try to speed up the tunnel and make the app/data access faster to those people who has to use it from another city far from my server?
Thanks
