Do NOT use the archive function if you are using the embedded database. The file will rapidly become large and is difficult to edit to remove old archives.
Thanks for suggesting the monitoring plugin in for openfire to store all conversations. Currently I am developing a Spark plugin, do you think it is possible to access the contents ie. the chat conversations stored in Openfire programatically, since I need to access each chat conversation?