Manual Prune Database

[houlejo]

Hi,

Is it possible to do a manual Prune Database ?
I don't want to run manual SQL queries, but I would like to call the function :: pruneDatabase when I want.

Thanks !

[DannyFaak]

Just run the function as seen in:

modules/schedulers/_AddJobshere.php

pruneDatabase() is the name.

You can simple do it by make a new php file in this folder with:

<?php

include('_AddJobshere.php');
pruneDatabase();
?>

Hope it helped,

Best regards,

Danny

[andydreisch]

Just curious about the need to prune the DB. Soft deletes cause very little overhead normally unless, of course, you've deleted 90% of the database!!

What's the motivation here? Your responses can help us understand usage better.

Thanks,

Andy

[sprunka]

I have no relation to the OP, but our company would also benfit from this functionality during our testing and data migration phase.

We are migrating data from SF, and are coming out with a lot of duplicates that would need to be merged, (due to the initial import being done improperly on our part, we think). We would like to wipe the database clean and start anew, but the cron for pruneDatabase failed.

Also as we experiment with importing and SOAP, we would like to be able to prune, so that new records with duplicate id, or fields do not get mixed in with old data.

We are in testing, using SugarCRM OS 5.0.0a (currently on a dev server but will be using 5.0.0b on what will be our live server).

If all goes well, we will be using Sugar and recommending it to all of our clients, including ones to whom we had previous recommended SF.

[kenlyle]

I am slogging through some sync issues, too, and being able to do a manual prune would be just one more variable that might help in solving sync issues.

I have a guy who has been merged out in Sugar, but still hanging around, Deleted=1, and causing me some confusion, because I have three records for him in Outlook and two in Sugar, and am not sure why I am not getting deletes in Outlook on sync, but, anyway, being rid of deleted records would be nice.

Ken

[malcolmh]

Hi,

Another easy way of running the prune database, assuming the cron scheduler is running. Just change the options for the prune database job in the scheduler to something like */5 * * * *, which would get the job running after five minutes.

Remember to change it back to the original values after you are finished.