ARIS Publisher database options (Derby vs SQL)

Hi Darcy,

As you have said in your first line you are having trouble under a high volume of active users. So it is clear SQL server or Oracle would be better for you. As they are more stable and better for high volume. If your footprint is small than derby database would be better for cost vs benefit. But for high number of active users it is better to use SQL server or Oracle. I assume your network architecture is not playing any trick here.

Also have a look at the installation manual for memory management/tuning in ABP.

Thanks

Abhijit Das

According to the admin guide, Derby database can be used for up to 10 users simultaneously viewing the export content. So, for larger number of users you should install MS SQL Server or Oracle.

Can anyone tell me if the ARIS Derby database (same thing as the Apache Derby) is the same database used (http://db.apache.org/derby/) with Business Designer?

According to the Admin Guide (Sec 4.8, pg 43) Business Publisher uses the Tomcat Derby (10 connections). 

However, I can't find a reference to the database used within Business Designer (Server Install) which states (Sec 4.4.1, pg 12) that the default database is recommend for up to 50 users - but can't find the reference to the database type/name.  If I was to guess it would be MySQL but unsure.

Thanks for your assistance.

The database is Sybase