Access to Postgres database over VPN Windows 7 - Very Slow [solved]

[timcs]

Hi

   I have an odd issue with Windows 7 PCs running my program which accesses a DBF file over a mapped drive. All is okay until such PCs are connected to a Windows VPN. When connected the program takes around 30 to 40 seconds to come back to the user, in this time it will be accessing the database to read the records.

I have tried the following for the file/full path of the DBF object properties :

the mapped drive is specified by its drive letter
the mapped area/drive is access by the UNC path such as \\servername
the mapped area/drive is access by the UNC path such as \\<ip address>

None of the above make any difference. However I have found that if the default gateway is unticked on the VPN settings it is much better BUT some sites do not work with this unticked.

Any suggestions would be appreciated.

[howardpc]

You could try altering the setting of the dbf's Exclusive property.

[timcs]

You could try altering the setting of the dbf's Exclusive property.

Thanks for your reply howardpc

I thought having this enabled would stop multiple access as this is a shared dbf file. Would this cause an issue?

[timcs]

Done some more testing and found that it is not the DBF file that is been held up over the VPN but when the program is accessing a postgres database using a SQL.

Any thoughts on this?

[timcs]

Solved this just changed the database connection reference from the name of the database to the IP address