Hi.
I have my CMS_INFOOBJECTS6 DB table with over 4 million rows and my system is slow.
I have found that my BO System is affected by DST Daylight bug, that produces many failed instances of scheduled reports, and i’m deleting all these failed insances using a JSP that I have found https://bobj-board.org/t/172811 .
I have modified this jsp and it works correctly but is so slow.
It can delete about 35000 instances in 1 hour.
Is it possible a DELETE of the failed instances directly to DB tables?
I think this operation is quickly.
Can I foun the failed instances with the query
select count * from BO3G.CMS_INFOOBJECTS6 where SI_INSTANCE_OBJECT = 1 and SCHEDULESTATUS = 3;??
An operation using SDK IInfoObjects.delete is equals as a delete in CMS_INFOOBJECTS6 table or the sdk delete function removes also othere rows/files?
Thank you
braianmei (BOB member since 2011-10-17)