I constantly see this in my OpenFire DB
Copying to tmp table
SELECT DISTINCT conversationID
WHERE sentDate >1232465246914
The date is always the same (1232465246914 aka Tue, 20 Jan 2009 15:27:26 GMT)
Is this supposed to be that or does this point to something wrong.
What is the best way to purge old archives. Is it to just delete conversation ID’s before a certain date from:
Did I miss anything? Is this the best way?