I was poking thru my database today and noticed that the jiveoffline table had 1,000,000+ rows in it! I sampled some of the messages and noticed it is filled with <tune/> stanzas from Pidgin. Checking further, each time somebody logs in, a message is placed in the database for each user not online and in the logged in user’s shared roster.
I suppose there is nothing wrong with this behaviour(?), but was wondering if other folks had ideas on how to work around it.
Do I periodically scrub the database for these entries via some script?
Hack at the openfire code to ignore these pubsub messages?
Yell at my users to log on more often to clean those out?
Maybe I am missing a setting to help with this? thanks!