在数据库中管理大量不断增长的表的好方法是什么？

I am building a web application for medical record keeping. A requirement for this application is logging all changes (view, create, update, delete) to a patients data and pretty much any other useful info in the system (login, cron run, data export, etc).I am building a web application for medical rec