Design question: Archive old data to another spreadsheet vs using security filter

[Lucinda_Mason]

I have two tables that will grow a lot. The old records, which meet certain criteria, will no longer be needed in my app.

Is it more efficient to:

1. use a workflow/report to copy those records to the Archive sheet?

2. use security filters to keep those records from being loaded in the app. Keeping them all in the original table.

Thanks.