Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

2

Access over the internet v.e.. r...y s....l.....o......w!

By
Cameron
on 5/22/13, 8:18 AM 4,646 views

Hi Our warehouse is separate from our office, Openerp connecting via the internet. LAN side it takes less than a second to load a page Internet side its a slow and painful 15 to 30 seconds to load a page!

We have 10MB download, 5MB upload microwave broadband at Server side. We have 2MB download 0.25MB upload at client

We use dynamic IP. - have tested with and without this, but no change?

Edit

Have been doing some testing and a quick review of the "log in page" using this gave this.

image description

Not that I understand the results! But 17/100 isnt good! I see one immediate area for improvement

Enable Compression - advise is to "Compressing resources with gzip or deflate can reduce the number of bytes sent over the network"

Edit 2 We have an 1/100 improvement :) - installed nginx - now scoring 18/100 - 82 more to go - still no compression!

Edit 3 We have had a small improvement :) - by changing the router - now scoring 34/100 - 66 more to go - still no compression!

Edit 4 We have had yet another small improvement :) - by giving the server another 2GB of memory - now scoring 36/100 - 64 more to go - still no compression!

Edit 5 Using Laura's link to Olivier below and "debugging tools" we have deduced that's its the first 2Mb of Java that's the slowing factor! Hence why I get a naff score when I test the log in page! (ok this is leading towards naff b'band, but - also noticed a couple of open wireless networks that we have tried (eg at shows) have what appear to be DNS issues somehow we can surf, but not use Openerp (cannot even ping)) .Once past the login page their is very minimal traffic!) I would still love to be able to enable compression on the 2MB of java! Any ideas?

do you access openerp on port 8069? did you install a proxy (nginx/apache) in front of it?

Davide Corio
on 6/5/13, 8:07 AM

Yes I have access to 8069 - didnt install a proxy! I know I have mod_deflate already installed which works (tested http://www.whatsmyip.org/http-compression-test/) on port 80 but not working on 8069! Should I have installed a Proxy? - Now install nginx see edit 2 above

Cameron
on 6/5/13, 10:40 AM

Bandwidth is not everything regarding network performance. What is the latency from the remote site to the server? are there any lost packets? Try this command while using OpenERP: ping -n 200 YourOpenERPServer and post the result (last line)

Mohammad Alhashash
on 6/5/13, 5:27 PM

vote for this. i think my installation is slow over internet too. i try other erp software on the same server its load faster. why openerp is slow there must be some problem that i do not know. over lan its ok.

iwan tantono
on 10/4/13, 6:45 AM
1

Ray Carnes

--Ray Carnes--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 7/24/13, 3:50 PM

LAN side it takes less than a second to load a page

If OpenERP is performing well via the LAN, then you should concentrate exclusively on the network.

Three most common causes of slow network performance:

  • Congestion (too much traffic from too many users)
  • Data corruption (traffic being sent more than once because it is damaged during transmission)
  • Collisions (traffic being sent more than once because it can't make it the first time)

How do other client/server applications perform on this same network? If they are slow, then OpenERP will be slow.

We have several clients accessing OpenERP from hosted virtual servers on Amazon and Rackspace infrastructure and it is no slower than LAN access.

Many thanks Ray - I think we need to decide on what is an acceptable speed, the warehouse department is getting a minimum of 10Mb down 5mb up broadband installed when this is done we will be able to assess its usability!

Cameron
on 9/11/13, 3:07 PM

Could you please test the latency ? if you just ping the server, how many ms ?

Tuxservices, Jeudy Nicolas
on 9/11/13, 3:30 PM

Dont know if this is an accurate result. At the moment I can only pinging from the local LAN out and back to our external IP (I can only do this since we change our router) - Results for 200 pings are Min 0ms Max 0ms Average 0ms - will try and do from an external PC sometime soon!

Cameron
on 9/11/13, 4:41 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 5/22/13, 8:18 AM
Seen: 4646 times
Last updated: 9/15/16, 9:25 AM