I have a filegeodatabase which holds my raster mosaics. Each Mosaic references about 500 tiff images. When I try to open the properties or eve just load the mosaic dataset into ArcMap it takes about 1 minute of waiting time which is a terrible user experience and very frustrating. Why is this and is there a solution?
Check if Building Overviews and Calculating Statistics improve the performance. Also delete Display Cache.
Also have a look at Improving the display of raster data—ArcMap | Documentation (arcgis.com)
If your FGDB is on a network drive try to copy it to local drive.
Just the FGDB that should be very small, not the images.
Reading a mosaic dataset required a lot of small requests. Network drive are not very good with it.
Have fun
Would the fastest option be to create the mosaic dataset in my sde and store the overviews there as well and have it reference the images from an UNC Path on the network?