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)
Abhijit Das on
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