Read the articles I just gave you in my last post.
The first of the three describes the library, and tells you exactly where to find it. Then you will know what drive it is on.
The second link describes how to use the Library Manager, which is what you would use to clone the library.
The third link is the thread of another user like you asking this exact same question. He was given good advice, so read it. He also evinces your same confusion about the nature of the library. That is common. Read what the other experienced users told him, and integrate that with what I'm telling you here. It all fits together.
And I am presuming the first way that was mentioned to move the database with the wiki link of rename, move and copy files is the way I would move the database...?
You're confused about the Rename Move & Copy Files link because you haven't read the other articles. The RM&CF tool mentioned in my first post is what you would use to move your MEDIA (audio) files, if you choose to do that later. Read those other articles; that's why I gave them to you.
Yes, I am struggling to understand but it seems the database is what your recommending to be on the SSD and the MP3, Flac music files can be on the HD.
As I said originally, if you have any concerns about Media Center being "slow" that is almost always because of the library (database). MC accesses the library (database) constantly, for everything you do. So putting the library (database) on the SSD will definitely improve performance. Once you have the library on the SSD, I imagine the only time you would ever notice any delay because of the media files being on the regular hard drive is if the drive goes to sleep. If your regular drive doesn't sleep (spin down) while you are using the PC, then I doubt you will have slowness issues if the media files stay there.
So read those articles. They contain information you need, and getting a better understanding of these concepts will help you do what you want to do. It's not very hard once you have the basics.