some questions about sql table between 'tig_pairs' and 'msg_history'
i know 'msg_history' used for storing offline messages,and i found some records as pkey='messages' in 'tig_pairs' to look like offline messages.
so what diff with two tables?
Added by Andrzej Wójcik over 1 year ago
Both tables may be used for offline storage by Tigase XMPP Server depending on its configuration. Judging from the fact that you have messages stored in both tables I suppose that you have configured it to store messages to both tables, this may be a result of enabling
OfflineMessages (@msgoffline@) and
MessageAmp (@amp@). In this case, you should consider storage of offline messages using
MessageAmp (as this is a newer solution than @OfflineMessages@) and disabling @OfflineMessages@) as the same functionality will be provided by @MessageAmp@.
I'm suggesting this solution as
msg_history table which is better suited for offline messages storage which will give you better performance.