Good to know what had happen with your library. Hope you will find the missing books somewhere in your backups.
An alternative of splitting libraries are virtual libraries. Maybe something you can think about.
https://manual.calibre-ebook.com/virtual_libraries.html