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.
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.
NX 11.0.1.mp01 | SW 2016 | TcUA 11.2.3
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.
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.
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: NX12.0
How to Get the Most from Your Signature in the Community