Re: Acitiviti tables "act_ru_actinst" too many
Hi, for 10k users with default settings, you are not expected to accumulate so many entries in the history tables, unless you are continuously updating them. Anyway, especially, if you are not using User Requests, cleaning up those tables provides no harm. Regards. On 06/02/24 14:50, yuefei@intelliprogroup.com wrote: Hi Francesco, I am using Apache Syncope version 3.0.5, database: pgsql 15 and running in a docker container, using the image apache/syncope:3.0.5 Best regards, yuefei.liu -- yuefei@intelliprogroup.com *From:* Francesco Chicchiriccò <mailto:ilgro...@apache.org> *Date:* 2024-02-05 17:30 *To:* user <mailto:user@syncope.apache.org> *Subject:* Re: Acitiviti tables "act_ru_actinst" too many Hi yuefei.liu, you should provide at least which Syncope version you are running, and also something about the environment (database? Tomcat? which versions?). Regards. On 04/02/24 06:40, yuefei@intelliprogroup.com wrote: Hello, I hope this email finds you well. I am currently using Apache Syncope as a user synchronization tool to sync user and user group information from one system to another. The number of users is approximately 10,000+. After running scheduled push and pull tasks for 2-3 months, I have noticed that the 'act_ru_actinst' table in the database has accumulated millions of records, leading to a slowdown in synchronization efficiency. I would like to inquire if it is safe to directly delete these data records. Your guidance on this matter would be greatly appreciated. Best regards, yuefei.liu -- Francesco Chicchiriccò Tirasa - Open Source Excellence http://www.tirasa.net/ Member at The Apache Software Foundation Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail http://home.apache.org/~ilgrosso/
Re: Re: Acitiviti tables "act_ru_actinst" too many
Hi Francesco, I am using Apache Syncope version 3.0.5, database: pgsql 15 and running in a docker container, using the image apache/syncope:3.0.5 Best regards, yuefei.liu yuefei@intelliprogroup.com From: Francesco Chicchiriccò Date: 2024-02-05 17:30 To: user Subject: Re: Acitiviti tables "act_ru_actinst" too many Hi yuefei.liu, you should provide at least which Syncope version you are running, and also something about the environment (database? Tomcat? which versions?). Regards. On 04/02/24 06:40, yuefei@intelliprogroup.com wrote: Hello, I hope this email finds you well. I am currently using Apache Syncope as a user synchronization tool to sync user and user group information from one system to another. The number of users is approximately 10,000+. After running scheduled push and pull tasks for 2-3 months, I have noticed that the 'act_ru_actinst' table in the database has accumulated millions of records, leading to a slowdown in synchronization efficiency. I would like to inquire if it is safe to directly delete these data records. Your guidance on this matter would be greatly appreciated. Best regards, yuefei.liu -- Francesco Chicchiriccò Tirasa - Open Source Excellence http://www.tirasa.net/ Member at The Apache Software Foundation Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail http://home.apache.org/~ilgrosso/
Re: Acitiviti tables "act_ru_actinst" too many
Hi yuefei.liu, you should provide at least which Syncope version you are running, and also something about the environment (database? Tomcat? which versions?). Regards. On 04/02/24 06:40, yuefei@intelliprogroup.com wrote: Hello, I hope this email finds you well. I am currently using Apache Syncope as a user synchronization tool to sync user and user group information from one system to another. The number of users is approximately 10,000+. After running scheduled push and pull tasks for 2-3 months, I have noticed that the 'act_ru_actinst' table in the database has accumulated millions of records, leading to a slowdown in synchronization efficiency. I would like to inquire if it is safe to directly delete these data records. Your guidance on this matter would be greatly appreciated. Best regards, yuefei.liu -- Francesco Chicchiriccò Tirasa - Open Source Excellence http://www.tirasa.net/ Member at The Apache Software Foundation Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail http://home.apache.org/~ilgrosso/