FTM is a databse
Whilst a small database like an Excel file can be fully loaded from the hard drive into memory, large databases like FTM and MS Access etc may well be larger than the amount of memory available.
So sometimes when running a large databases, the program occaionally has to load information from the hard drive and save other data whilst operating.
Now conventional platter hard drives, good as they are, are many times slower than a sold state drives (SSD) and RAM.
It follows therefore that a SSD can improve the speed of overall operation where the program is swapping material in and out of the hard drive.
I understand that now you can also get so called combo drives with a mixture of an SSD and a conventional hard drive. I am sure there are lots of refernces in Googl if you are interested.
The logic is such that data needed for a particular program is moved from the conventional hard drive to the SSD as the SSD is often much smaller than a regular hard dive.
I guess one day very soon regular hard drives will disappear and we will use large SSDs??
So yes a SSD can improve overall speed especially with very large files with lots of media etc.
But RAM is much more critical, followed by 64-bit, followed by a fast processor.
And the Mac version of FTM is much faster than the Win version so your choice of OS is also part of the route to improved performance.