Author Topic: WAN Performance/Best Practices (Read 9166 times)

jdrake4 · « **on:** March 26, 2007, 03:04:27 pm »

We recently started doing development with people located in different parts of the country. We have noticed that EA is very slow over the WAN. (We are currently using an Oracle database in the backend.) Does anyone have a best practices approach for how to use EA over a WAN? Should we enable source code integration and check packages in and out or is there a better solution?

Thanks

thomaskilian · « **Reply #1 on:** March 26, 2007, 11:05:31 pm »

Hi,
there are a lot of discussion around that. In general EA is very chatty when talking with the repository. Instead of using one SQL doing it all it uses quite some sinlge SQLs. What you should consider is having a version management and one repository manager. Users can check out the model and work locally. The repository manager will consolidate the changes brought in be the single users. You can distribute work by making single persons responsible for single packages. If you have a lot of people working distributed it's always a good idea to have a kind of a versioning plan: how do changes in part A influence B and what does B need to do in order to be aware of the A changes. But that is not EA related, this is a quite common thing, isn't it?

Dave_Bullet · « **Reply #2 on:** April 01, 2007, 03:07:32 pm »

Hi jdrake4,

Does Oracle come with some sort of database replication technology?

We found the same problem with EA performance but it is solvable using MS SQL Server with merge replication between database instances. We have been using EA on 2 replicated databases succesfully for the last month.

There is a bug with EA which Sparx fixed in the latest build (copy and paste diagrams was broken on a replicated SQL Server EA database).

If you switch to SQL Server - I can give you the replication scripts you need to set this up plus an amended base SQL script to create the EA tables correctly for replication.

Cheers,
David.

jdrake4 · « **Reply #3 on:** April 02, 2007, 07:08:58 pm »

Yes Oracle does support replication, however our DBA group said that multi-site master would be too tough for them to tackle for a non-mission critical system.

I would definitely consider moving it to SQL server if you could provide me with the replication scripts

You can send me an email at
john(dot)drake at microchip(dot)com

Thanks for your help!

sargasso · « **Reply #4 on:** April 03, 2007, 01:34:34 am »

Quote

however our DBA group said that multi-site master would be too tough for them to tackle for a non-mission critical system.

By gosh, this one almost snuck past me.

So we're back to the 1980's. Support for the G/L, which has a per annum support cost of $20gazillion is more important than actually supporting the tools that people use to create the corporation's wealth. On second thoughts, maybe we're back to the 1880's.

Kill them. Your worth more anyway.

bruce

«Midnight» · « **Reply #5 on:** April 03, 2007, 01:58:18 am »

Quote

...however our DBA group said that multi-site master would be too tough for them to tackle for a non-mission critical system.

I would definitely consider moving it to SQL server if...

I take it you work for a DBA company. It must be nice for them (the DBAs) to set everyone's priorities without having to go through needless layers to corporate oversight.

Doubtless your DBA group would welcome the chance to support a second DBMS for such a non-mission critical system. Remember to make extra sacrifices to them, perhaps increase your offer, whatever it takes.

Paolo F Cantoni · « **Reply #6 on:** April 03, 2007, 03:20:33 am »

Quote

So we're back to the 1980's. Support for the G/L, which has a per annum support cost of $20gazillion is more important than actually supporting the tools that people use to create the corporation's wealth. On second thoughts, maybe we're back to the 1880's.

Oh come on bruce, You know as well as I do that modelling is arty farty stuff with NO practical benefit...

Now get out of the way and let them code triggers and REAL stuff...

Paolo

(it's ironic, )

mikewhit · « **Reply #7 on:** April 03, 2007, 03:49:58 am »

Why not put their noses right out of joint and use MySQL?

That'll have the Oracle rep worrying

«Midnight» · « **Reply #8 on:** April 03, 2007, 04:01:08 am »

No, they (Oracle) bought the InnoDB engine. They'd just turn MySQL off...

Dave_Bullet · « **Reply #9 on:** April 03, 2007, 12:40:47 pm »

G'day John,

No problem. I will email you a word document that describes the steps and includes the scripts. You'll just need to rename servers. The other thing that you'll need to check is user IDs / permissions to grant replication between SQL servers. Something my DBA did for me.

Tell your oracle DBAs - that I am not a DBA and it only took me 8 hours to initially setup (not knowing anything to begin with). So I would expect with their vast experience, they could set up Oracle replication in no time unless Oracle is hard to administer :-)

Cheers,
David.

«Midnight» · « **Reply #10 on:** April 03, 2007, 02:20:48 pm »

Dave,

Please check your messages. I've left you my coordinates in case you can share this with me.

Thanks much,
David

mfritz · « **Reply #11 on:** April 06, 2007, 04:02:23 am »

there is another way using EA within a wan environment: try citrix!

i have worked in such an environment, where the EA-repository was located on an oracle-server and the citrix server right beside connected with a fat cable to the oracle.

if you just have a 2 mbit line, this solution works fine as long as the citrix can handle the number of clients.

Martin Terreni · « **Reply #12 on:** December 23, 2007, 03:18:26 am »

Quote

Hi jdrake4,

Does Oracle come with some sort of database replication technology?

We found the same problem with EA performance but it is solvable using MS SQL Server with merge replication between database instances. We have been using EA on 2 replicated databases succesfully for the last month.

There is a bug with EA which Sparx fixed in the latest build (copy and paste diagrams was broken on a replicated SQL Server EA database).

If you switch to SQL Server - I can give you the replication scripts you need to set this up plus an amended base SQL script to create the EA tables correctly for replication.

Cheers,
David.

Could you mail them to me too?THANKS!

Martin Terreni · « **Reply #13 on:** December 23, 2007, 03:18:32 am »

Quote

Hi jdrake4,

Does Oracle come with some sort of database replication technology?

We found the same problem with EA performance but it is solvable using MS SQL Server with merge replication between database instances. We have been using EA on 2 replicated databases succesfully for the last month.

There is a bug with EA which Sparx fixed in the latest build (copy and paste diagrams was broken on a replicated SQL Server EA database).

If you switch to SQL Server - I can give you the replication scripts you need to set this up plus an amended base SQL script to create the EA tables correctly for replication.

Cheers,
David.

Could you mail them to me too?THANKS!

Martin Terreni · « **Reply #14 on:** December 23, 2007, 03:18:50 am »

Quote

Hi jdrake4,

Does Oracle come with some sort of database replication technology?

We found the same problem with EA performance but it is solvable using MS SQL Server with merge replication between database instances. We have been using EA on 2 replicated databases succesfully for the last month.

There is a bug with EA which Sparx fixed in the latest build (copy and paste diagrams was broken on a replicated SQL Server EA database).

If you switch to SQL Server - I can give you the replication scripts you need to set this up plus an amended base SQL script to create the EA tables correctly for replication.

Cheers,
David.

Could you mail them to me too?THANKS!

Sparx Systems Forum

News: