Hi Lauren,
In addition to Dan's and Tim's comments, the advice against using a remote database for the CSE is somewhat hidden away in the Gen 8.6 documentation under Client Server Encyclopedia Administration.
After "Optimize Disk Usage" there is this note which should probably be under a different heading:
"Note:
While it is possible to configure the CSE environment such that the database is on a different physical machine, it is not a recommended configuration for performance reasons. The architecture of the normal execution of the CSE process is such that there are many individual messages that are passed between the CSE process and the database process. This leads to performance issues because any network latency between the two machines is multiplied by the number of requests made. If the current configuration is necessary, then care must be taken to ensure that the communications infrastructure between the two machines is as quick as possible."
Having said that, with improved modern-day network bandwidths using a remote database may still give good/adequate performance, especially if the database is residing on a VM that is particularly tuned for good Oracle performance and that cannot be achieved on the VM where the CSE software is installed. Due to environment specific conditions, testing both local and remote database options per Dan's advice would be the way to go.
Regards,
Lynn
------------------------------
Lynn Williams
Senior Principal Support Engineer
Broadcom Software
Australia
------------------------------
Original Message:
Sent: Aug 06, 2023 06:35 PM
From: Tim Dargavel
Subject: Now Available: CSE on Linux
Hi Lauren
The reason for that recommendation is that the CSE server-side software is *extremely* chatty - that is - very high quantities of I/O calls to the underlying database. By ensuring the CSE software and the database reside on the same server (physical or virtual), you avoid introducing network latency into the CSE operations.
Tim Dargavel, Facet
Original Message:
Sent: 8/4/2023 3:57:00 PM
From: Lauren Holden
Subject: RE: Now Available: CSE on Linux
Can the CSE on Linux be set up on a Linux VM ? and does the CSE database need to reside on the same Linux server the CSE software is installed. I am currently conducting research to move our Unix CSE to Linux and I know it was a recommendation for the Unix platform to keep the CSE database on the same Unix Server the CSE software was installed. Thank you.
Original Message:
Sent: Jun 22, 2023 02:47 PM
From: Kim Peelman
Subject: Now Available: CSE on Linux
FAQ:
------------------------------
Kim Peelman
Kim.Peelman@broadcom.com
Product Owner, Gen
Broadcom
Plano, TX
Original Message:
Sent: Jun 22, 2023 02:46 PM
From: Kim Peelman
Subject: Now Available: CSE on Linux
I am pleased to announce that the Gen Client Server Encyclopedia on Linux is now available.
The Gen encyclopedia is a central repository of objects that allows multiple users to work on several development projects at the same time. The Client Server Encyclopedia (CSE) provides distributed or downsized support for an encyclopedia functionality. It is now available for Linux platforms, in addition to Windows and Unix.
If you are licensed for the Gen CSE on another platform, you will automatically have access to CSE on Linux at no additional cost.
Did you know? This enhancement originated from this Community Idea submission. Submit your enhancement ideas and vote for ideas that impact you. You can shape the roadmap for Gen!
Note: Gen has moved to a continuous delivery model. To learn more about Broadcom's approach to continuous delivery and maintenance best practices, read HERE.
------------------------------
Kim Peelman
Kim.Peelman@broadcom.com
Product Owner, Gen
Broadcom
Plano, TX
------------------------------