You'll understand when/if your Plex media library grows so large that every rescan takes a week.
I just checked: my "com.plexapp.plugins.library.db" is 24Mb. Meanwhile, I have some custom apps with SQLite db's that are >10Gb and I don't have performance issues.
So I don't see how big a library have to be for its db to become a bottleneck?