Andy – I have Project and Event folder on internal drive. Only original media files was on USB2 disk.
And with SQL optimisation I was pointing to sequential vs. index searching in tables. Even if you have modern servers with lot of RAM, it’s not always possible to put 500GB table into RAM 🙂
So, modern HW is good to have, but programmers must optimize their code always.
What if Apple is planing to implement multiuser access to Events. Imagine 100 editors accessing same media at same time.
I still hope that there is no reason for FCPX to access all original media used on timeline.