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)