cancel
Showing results for 
Search instead for 
Did you mean: 

DB selection Oracle VS SQL

Solution Partner Experimenter Solution Partner Experimenter
Solution Partner Experimenter

good morning all

 

My company is about to embark in a Teamcenter PLM project for one of its divisions.

 

From a performance standpoint would you suggest to use Oracle or SQL?

All aspects (Infrastructure/network/storage etc) being the same and taking economics out of the equation how much performance gap could we expect selectiong one or the other?

 

We should have some 1000 users working on rather complex Industrial Equipment.

 

thanks for your comments/opinions.

Mark

 

 

3 REPLIES

Re: DB selection Oracle VS SQL

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

Although MS SQL was a more recent addition than the everlasting Oracle, the performance is basically identical. Yet, there are a lot of other considerations when selecting a database flavor than performance alone. Mainly, what database flavors do they support in-house already? Hiring a new DBA can be difficult. Another major consideration is J2EE or .NET? The fundamentals are, well, fundamental.


Randy Ellsworth, Teamcenter Architect, Applied CAx, LLC
NX 11.0.1.mp01 | SW 2016 | TcUA 11.2.3
Evaluating:AW 3.2

Re: DB selection Oracle VS SQL

Siemens Phenom Siemens Phenom
Siemens Phenom

I've used both over the years.  Performance is similar. What matters more is how the DBs are configured and on what hardware they are configured on.


Larry Carpenter, P.E.
CAxPLM Architect @ Siemens Molecular Imaging
Past Board Member @ PLM World, Inc,

Re: DB selection Oracle VS SQL

Esteemed Contributor
Esteemed Contributor

If you do have a Microsoft environment and Microsoft trained administrative staff, stay with Microsoft SQL Server.

Oracle has its roots in the UNIX world, so it is not so easy to understand by someone who has never been in touch with UNIX.

Stefan Pendl, Systemmanager CAx, HAIDLMAIR GmbH
Production: NX10.0.3, VERICUT 8.0, FBM, MRL 3.1.4 | TcUA 10.1 MP7 Patch 0 (10.1.7.0) | TcVis 10.1
Development: VB.NET, Tcl/Tk    Testing: NX11.0 EAP, NX12.0 EAP

How to Get the Most from Your Signature in the Community