Speed up GP RECONCILE and CHECK LINKS
Suggested Tue, 06 Mar 2018 21:49:11 GMT
Issue: Check links and reconcile takes far too long to run
If the business logic were pulled out of dexterity and these were re-implemented in SQL using set based operations, this would transform a very painful aspect of running GP on large databases.
Once in SQL it could be scheduled from SQL jobs and results emailed via SQL for those of us with those skills. This would address the issue of unattended scheduling of these tasks which is another suggestion.
Even if just the key three pilars of SOP/POP/IV modules were addressed, I'm certain an operation that currenly takes more than a weekend duration to run (currently), would be reduced into minutes.
Thanks for the suggestion. We will consider this one (along with your other suggestion) for a future release.