Hello All,
I know this is very OLD post, I guess we were at 7 or 8 th Version :).
Issue: Currently we are in 15.8.1, we need to delete more then 70000 Projects from our environment and using Delete Projects is taking 5- 10 Mins if Actuals are huge it may take hours as well. Do any one come to any conclusion that we can delete bulk Projects?
We are deleting 10 Projects per 30 mins in OFF PEAK hours only but it will take EONS to delete.. Is there any findings to delete projects faster?
------------------------------
Awadhesh Dammani (Addy)
Sr.Consultant
Clarity PPM
Location: India
------------------------------
Original Message:
Sent: 02-08-2010 09:50 AM
From: Martti Kinnunen
Subject: Re: Clarity Job - Delete Projects
Just tested it in 7.5.3.3546 FP05 024The only timeperiod marked for deletion and the only posted timesheet for that just disappeared when I ran the Delete projects job.That is ran it 5 minutes after marking the timeperiod for deletion. (The normal safe waiting time for any data to be picked up by any job). You certainly know your options:standard job - unimaginable timecustom job - just too many uncertainties with the 150 tables (I hope I may quote you on this when people propose to delete a recrod from srm_projects or something similar)improving performance with a version upgrade - not an option There still isupgrading HW for better performancehousekeeping Clarity and DBtrying to accomplish what is possible which daily scheduled happy deletetion hour off peak usage with prescheduled jobs and scripts. Martti K.