Delete large list wdduncan  2018-10-29 15:04
Status: Closed
 

I have a list on my system that says it has 999,999 records. When I try to delete it using the list manager or the folder manager, the application becomes unresponsive. I that another way to manually delete the records?

 
 
Jon (LabKey DevOps) responded:  2018-11-12 14:48
Hello,

There are a few approaches to trying to delete from a list that size.

You could try to use the API and do deletes in batches until it gets to a reasonable size for you to then delete all of the rows or delete the list itself, but this would require some programming on your part.

You could also see whether it is possible to delete individual rows within the UI rather than the whole list of rows at once, however an API delete would allow you to process more row deletions than the UI would since it wouldn't need to render the UI after the delete of a row.

Regards,

Jon
 
Jon (LabKey DevOps) responded:  2018-11-12 15:31
Additionally, the upcoming 18.3 Release build of LabKey should also better handle deletions as well, so it might be advantageous to upgrade and reattempt your deleting efforts.

Regards,

Jon
 
wdduncan responded:  2018-11-13 09:55
Thanks Jon.