Author Topic: Performance issues after Oracle upgrade? (Read 11588 times)

Kristofer · « **on:** April 05, 2016, 07:49:48 pm »

Hi!

We recently upgraded Oracle from 11.2.0.3 to 12.1.0.2 and noticed some performance degradation. We are however not sure if it is because of the Oracle upgrade, or something else, since we cannot see anything remarkable regarding performance in the query execution.

Currently we are running 11.2.0.3 and 12.1.0.2 in parallell to test, and the most noticable is in the logon process. But it is also (sometimes painfully) slow to just open the properties of an element, or navigating in Project Browser.

Has anyone else noticed any changes regarding performance between Oracle versions?

Geert Bellekens · « **Reply #1 on:** April 05, 2016, 08:15:52 pm »

Kristofer,

Unfortunately Oracle seems to not work happily together with EA.
Most complaints about performance I've seen were from Oracle users.

If at all possible I would advice to switch to MySQL or SQL Server.

Geert

Helmut Ortmann · « **Reply #2 on:** April 05, 2016, 11:31:07 pm »

Hi Kristhofer,

I agree to what Geert said. My experiences are the same.

Helmut

Kristofer · « **Reply #3 on:** April 06, 2016, 08:25:48 pm »

Okay, thanks for the information!

I don't think we can change from Oracle however. :-(

Geert Bellekens · « **Reply #4 on:** April 06, 2016, 08:41:50 pm »

In that case you'll have to ask your DBA's to optimize the database for very much very small queries.

EA can execute hundreds of tiny queries per second. So in these cases network bandwidth and the number of simultaneous requests the server can handle become more important then processing power.

If you monitor the database server you'll probably notice that the processor is hardly doing anything for Enterprise Architect.

Geert

Kristofer · « **Reply #5 on:** April 13, 2016, 07:30:58 pm »

I see.

I think that I will also take a look at the Cloud Service. It mentions something about improved performance.

Geert Bellekens · « **Reply #6 on:** April 13, 2016, 07:42:36 pm »

Quote from: Kristofer on April 13, 2016, 07:30:58 pm

I see.

I think that I will also take a look at the Cloud Service. It mentions something about improved performance.

Cloud Services will only improve performance in WAN setups, not in LAN environments (contrary, it will probably slow things down in a LAN environment)

Geert

Kristofer · « **Reply #7 on:** April 13, 2016, 09:19:37 pm »

Oh, okay.

I think I somewhere read that the cloud service would make multiple data requests in a single call to the database, and in that way speed up things. But i cannot however find where i read this.

Eve · « **Reply #8 on:** April 14, 2016, 09:09:42 am »

The cloud service does run multiple queries concurrently, but in a LAN environment this will have minimal effect.

Glassboy · « **Reply #9 on:** April 14, 2016, 09:26:05 am »

Quote from: Simon M on April 14, 2016, 09:09:42 am

The cloud service does run multiple queries concurrently, but in a LAN environment this will have minimal effect.

Unless each network connection is being authenticated. Systems that do hundreds and thousands of small conversations are the bane of poorly performing authentication servers. You can go from no apparent problem to hell very quickly.

Kristofer · « **Reply #10 on:** April 14, 2016, 04:32:15 pm »

Thanks everyone! Then the Cloud Service does not seem to do much for us in our current environment.

MartialComeau · « **Reply #11 on:** August 24, 2016, 04:45:20 am »

We are having exactly the same problems. We did benchmarks that gives 3 to 8 times faster for SQL Server, depending on the operations. We are moving to SQL Server 2014.

Geert Bellekens · « **Reply #12 on:** August 24, 2016, 04:47:43 am »

Quote from: MartialComeau on August 24, 2016, 04:45:20 am

We are having exactly the same problems. We did benchmarks that gives 3 to 8 times faster for SQL Server, depending on the operations. We are moving to SQL Server 2014.

I'm sure you'll be much happier after the move.

Geert

Sparx Systems Forum

News: