So how do you mass delete old products? Do you really have to delete one at a time?

Furthermore, if you delete one by one, or possibly mass delete (let say 200 products); would the remaining record id's create a problem? When year after year you create newer and delete old products? Can the table be somehow compacted?