Yes, it does take a long time to transfer a table (depending on size) onto the drive ready for a search. That is why I want to eventually get one for each table.
It can take 40 minutes or more to transfer a table over 400GB.
There now normal drives that are almost as fast as SSD's.
They are larger (1TB) and cheaper.
I will probably buy some of these just for my RBT's. Even if it speeds up the key search by 50% I will be happy, but supposedly, they are faster than that but not as fast as an SSD. SSD's have a very limited life too, so you should consider that.
I can't remember how long they are expected to last, but it is nowhere as near as a normal drive.
dog-man