1
General Board / Performance and scalability issues multi-country
« on: May 07, 2013, 01:06:05 am »
Hello,
I'm facing a new issue regarding EA performance over a database storage.
My company has two teams, one in Europe and another in USA. We have a single database (Postgres) storage, which is located in Europe. The USA team are facing HUGE lag when trying to access the elements in their EA (which is connected to the database in EU). Ping and speedtests show that the network should not be a problem here, since RTT is usually 135 ms, 200 maximum.
I would like some suggestions in what to explore here. What could the problems, and possible actions, be?
We thought about replicating our Postgress. However, a lazy sync strategy would imply in loss of integrity, and some different teams work on the same element sometimes. Using a eager syncronization strategy I'm afraid I came back to the original problem.
Maybe the problem is the Postgres itself? Or maybe EA is not handling well the locks? The team are right now 15/5 (EU/USA) but should achieve 50/30 in no more than two quarters.
Any help is appreciated.
Best,
Pedro
I'm facing a new issue regarding EA performance over a database storage.
My company has two teams, one in Europe and another in USA. We have a single database (Postgres) storage, which is located in Europe. The USA team are facing HUGE lag when trying to access the elements in their EA (which is connected to the database in EU). Ping and speedtests show that the network should not be a problem here, since RTT is usually 135 ms, 200 maximum.
I would like some suggestions in what to explore here. What could the problems, and possible actions, be?
We thought about replicating our Postgress. However, a lazy sync strategy would imply in loss of integrity, and some different teams work on the same element sometimes. Using a eager syncronization strategy I'm afraid I came back to the original problem.
Maybe the problem is the Postgres itself? Or maybe EA is not handling well the locks? The team are right now 15/5 (EU/USA) but should achieve 50/30 in no more than two quarters.
Any help is appreciated.
Best,
Pedro
