Hello. Has anyone in the community had success using the dbArchive tool to archive and/or delete large numbers of events? We are currently investigating archiving in assyst, and we have about 1,400,000 events to either delete or archive. From our testing, it seems that the tool takes about 21 seconds per event, which would mean archiving the required events in our database would take months. We posed a question to IFS support about how to increase the speed or archiving, but they were not able to provide any guidance.
Event archiving processing times
Best answer by Teslatradeup
Hi Duncan,
We are currently working with IFS for an automated archive solution as we have millions of records to delete as well.
We had extremely slow performance where deleting 200 events would take 45 minutes.
They identified an index that could be added…. and we lowered the processing time from 45 minutes to 2.5 minutes to delete 200 events.
I can’t seem to find the index information however… But just quote our incident number in working with IFS which is 369418. Perhaps you’re DB would benefit from that same index… or at least you could test it in non-prod to see if it helps.
One thing to note though - when running multiple batches, archiving so many events is causing our DB to temporarily disconnect. We are still working on that one…. :(
Cheers.
Martin
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.