When installing OpenFire there is an option to use the internal database or to use an external database such as SQL Server (or maybe Microsoft DeskTop DataBase Engine). This is installing version 3.4.5, however these questions probably apply to all OpenFire versions.
The install mentions performance being better with an external database.
Is using an external database significantly better or are there other benifits and can anyone help to quantify this better performance?
Using MSDB and the openfire_sqlserver.sql setup script gives the following warning:
>> Warning! The maximum key length is 900 bytes. The index ‘jiveSASLAuthoirzed_pk’
>> has maximum length of 4128 bytes. For some combination of large values, the
>> insert/update operation will fail.
Is this warning significant when OpenFire is in production?