DW

We have had trouble with our Publisher system locking while under a high volume of active users.

In an attempt to resolve this long term, we haev been building an ARIS 7.2 installation on a seperate server for testing.

Our current system uses the Derby database but we had received a suggestion that SQL would be more stable for our use base (up to 100 concurrent users).

Can anyone here comment on the pros and cons of using the Derby database versus SQL database? (I've had conflicting suggestions from the folks I've talked with to date and would like further feedback to identify an consensus)

by Abhijit Das
Posted on Sat, 09/01/2012 - 16:47

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

0
by Boris Borchev
Posted on Tue, 09/04/2012 - 13:29

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.

0
by Stuart Holtby
Posted on Wed, 09/05/2012 - 16:04

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.

 

 

 

 

0
by Ignacio Arriagada
Posted on Tue, 11/05/2013 - 13:47

The database is Sybase

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock