topic Re: Best way to delete history in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/best-way-to-delete-history/m-p/201559#M154689 <HTML><HEAD></HEAD><BODY><SPAN>You are loading ALL 100K objects in memory. That is not going to scale.</SPAN><BR /><SPAN>That is why paging was invented. The query api supports it.</SPAN></BODY></HTML> Wed, 18 Feb 2015 16:09:18 GMT jbarrez 2015-02-18T16:09:18Z Best way to delete history https://connect.hyland.com/t5/alfresco-archive/best-way-to-delete-history/m-p/201558#M154688 I created 100K process records in the H2 database and want to delete.&nbsp; I saw a post to use the deleteHistoricProcessInstance() API.&nbsp; So I wrote the following code &lt;blockcode&gt;HistoryService historyService = processEngine.getHistoryService();HistoricActivityInstanceQuery haiq = historyService.cr Mon, 16 Feb 2015 08:30:26 GMT https://connect.hyland.com/t5/alfresco-archive/best-way-to-delete-history/m-p/201558#M154688 astrand 2015-02-16T08:30:26Z Re: Best way to delete history https://connect.hyland.com/t5/alfresco-archive/best-way-to-delete-history/m-p/201559#M154689 <HTML><HEAD></HEAD><BODY><SPAN>You are loading ALL 100K objects in memory. That is not going to scale.</SPAN><BR /><SPAN>That is why paging was invented. The query api supports it.</SPAN></BODY></HTML> Wed, 18 Feb 2015 16:09:18 GMT https://connect.hyland.com/t5/alfresco-archive/best-way-to-delete-history/m-p/201559#M154689 jbarrez 2015-02-18T16:09:18Z