I do not think partition can server your purpose. Can you share some details here to see whether we have something to propose.

1. How much database size?

2. How much the Load volume will be ? In terms of Insert/update/Delete

3. How long the Load is running now?

Thanks