This branch (as is) only affects new installs. It does not modify activity types on existing systems. My concern here was that, depending on the size of the actor.usr_activity table, some manual data cleanup may be needed/preferred before toggling the transient value, since setting an activity type to transient could result in huge numbers of deletes in a short period of time.
Would it be helpful to have a tool (SQL script) to clean up the usr_activity table by deleting all but the most recent entry per user per activity type that people can run off-hours before modifying their transient settings?
Code pushed to change the default value for the transient column from FALSE to TRUE.
http:// git.evergreen- ils.org/ ?p=working/ Evergreen. git;a=shortlog; h=refs/ heads/user/ berick/ lp1570909- usr-activity- transient
This branch (as is) only affects new installs. It does not modify activity types on existing systems. My concern here was that, depending on the size of the actor.usr_activity table, some manual data cleanup may be needed/preferred before toggling the transient value, since setting an activity type to transient could result in huge numbers of deletes in a short period of time.
Would it be helpful to have a tool (SQL script) to clean up the usr_activity table by deleting all but the most recent entry per user per activity type that people can run off-hours before modifying their transient settings?