> Delete in batches (as opposed to one-by-one), and without moving the event objects out of the database server – try to avoid loading them in the cleaning proc

> Delete in batches (as opposed to one-by-one), and without moving the event objects out of the database server – try to avoid loading them in the cleaning process before removing them, and don’t bother sending removed items back over the wire. Nah, I am quite sure for item in conn.query('SELECT * FROM event'): if item.created_at < created_at_horizon: conn.exec('DELETE FROM event WHERE ' + ' AND '.join(f'{k} = :{k}' for k in item.__dict__.keys), item.__dict__) is fine, so I won't even bother measuring it. It's also secure, don't worry: as you can see I used prepared statements in it.