After months of development the moment comes where one must endure the human firewalls (system administrators).
We will have 10000 contacts and in deveopment environment i always used a MSSQL database.
Now i was told every application must’nt directly access Databases inside the infrastructure, that should be done through Web services.
As i have no time to change openfire database transactions to webservices i am willing to use the embedded database.
I expect a lot of contacts but phew users using the server simultaneously (max 200). where will the limitations of the embedded database will be more problematic? roster retrieval? authentication? database size? throughtput? backup and admin?
tx a lot!