How to solve the problem of slow operation of the OpenERP web interface through an external IP?

Question

CRM

On the server (Asus 1201N, atom 1.6 2 cores, 2gb DDR2, Linux ubuntu 12.04 64x) OpenERP version 7.0 is installed and fully configured.
The server is accessible from the outside via the ASUS WL500GP.v2 router.
Work with the program is built through a web interface.
When accessing through the local network, everything works quickly and smartly - page loading is 0.2-0.5 seconds.
When accessing remotely (via an external IP), it slows down a lot - page loading is stretched to 1.5-3 seconds.
When working through a proxy (SOCKS proxy through an SSH tunnel to the server), OpenERP works just as fast as in a local network.
I ask you to help me understand what exactly the problem of the brakes can sneak in, and help in solving it.
Thank you.

Answer 1

Try to look at the download diagrams (waterfall diagram, in firefox it is F12->Network) when opening the page from the local network and from outside and compare.

Answer 2

Thanks for the advice @throughtheether !
Here's what happened (links to DropBox) :
Outside and on the local network .
So I understand that the router / provider is to blame. Router ASUS WL500GP.v2
and provider beeline Moscow . The provider took the external IP. Port forwarding is configured on the router via Nat Setting -> Virtual Server . Can you please tell me what other tests can be carried out in order to determine who is so slow?

Answer 3

1) when connecting outside, the time for DNS resolution increases to hundreds of milliseconds. If you plan to access from the outside mainly from one host, then you can try to register DNS on it, for example, 8.8.8.8, and plot the diagram again.
2) most importantly - for some reason, the time to establish a tcp connection increases to thousands of milliseconds. Here you can check the ping from the client to the external address of the server (that is, the one that is used when connecting). If you have a Linux machine with Internet access (or Linux is on the client), you can use hping like this:

hping -c 10 --syn --destport 80 <IP адрес или имя хоста сервера>

Answer 4

The issue with the long Connecting was resolved:
I re-flashed the router, re-registered the Firewall entries and set up Virtual DMZ.
On the server: OpenERP configured via https using Apache.
Loading time decreased to 2 seconds.
The diagrams have changed and now the biggest time is spent on Waiting .
There is already a problem, as I understand it, in the optimization of the Apache server.
Thanks for the tip @throughtheether .

Answer 5

There is already a problem, as I understand it, in the optimization of the Apache server.

I agree with you.
Happy to help.