Interesting sidebar
There seems to be a variety of different LR things that have an impact on performance, and I haven't completely figured out the exact nature of each.
1) the LR cache. you specify location and an upper size limit (max 200GB). i'm not 100% sure what *exactly* goes there, there was some talk of image previews, but it's clear not ALL image previews go here (and previews is a whole topic onto itself!)
2) the catalog. as
@Anjin San suggests, you probably want this on a SSD and probably a FAST ssd (nvme). one gotcha here is the catalog directory also includes some previews (?!?!), so it can get a lot larger than it seems would be necissary. there also seems to be some upper limits where a performance tends to get slow even on a fast drive