very slow using Photos on external hard drive
I've been using an external hard drive (2T, Mac OS Extended) for some time (about 40,000 images = 223 Gb). This was a solution to running out of storage space on my old Macbook Air. Call me old-fashioned, but I don't like the idea of having my images in the Cloud. In any case, I now have a newer Air (M2 chip, 8 GB memory) and it appears there is enough space to store all of my images with about 100 Gb to spare, so I was planning to transfer them. It's always been slow to search and manage metadata using the external drive (even worse now, having to go through a hub, I think). Every time I make an effort to make changes and toss old photos (to lessen the load, as it were), it just takes so long that I give up before ever making a dent. I assume Photos will run significantly faster and more efficiently on the resident hard drive. Is this true, or are there other options available? THANKS.
MacBook Air, macOS 15.3