by vicnice wrote:Unfortunately purging is ridiculously slow (kraada and whiterider would know more specific numbers, but yeah, it is very slow on large databases). I think it is because when it is purging it has to delete things from a lot of locations in order to make sure the data remains consistent.
Vicnice's assumption is correct. Each hand has to be deleted up to 10 times from 7 different tables. Also each session is purged in a single transaction, for consistency reasons, so that can add up to a lot of disk activity.
I do have a small amount of good news though.
I did find one small bug in our purging process which might make it a tad bit faster especially for sessions with lots of players in it. (Basically long sessions.) In addition I also added performance logging for the purges. That way when you run into these extremely long purges we can get some idea of how long it is taking per session and what kinds of sessions are taking longer. With enough information we might be able to figure out how to optimize these bigger purges.
All of this will be available in the next Beta.
