I work for a small graduate school producing 6-10 short documentaries each year. Most of these projects highlight some aspect of the student experience: classroom, office hours, socializing, internship, family life on our residential campus... So that I'm always ready, I have built up a large inventory of B-roll covering these various aspects of the stuent experience. Most of this content remains current from year to year.
Until recently, I organized all these B-roll clips into one library on a local HDD. This was excellent, because I could search one library for "Dr. Jill Smith" and find all clips titled or tagged "Dr. Jill Smith".
But recently, I have found that Final Cut Pro X 10.0 Events and 10.1 Libraries alike struggle with handling a large number of clips. They are sluggish to load (into RAM?) and frequently give me the "spinning beach ball". In response to this performance issue, I started a new B-roll library for 2014 (also on a local HDD). Its performance is better than my 2011-2013 B-roll library, which I attribute to its having fewer clips (does that sound right?). The result is that now my B-roll is split across multiple libraries. Furthermore, my keyword hierarchy isn't duplicated to my new 2014 B-roll library.
This is a problem for me because I need to be able to search all of my B-roll quickly. I'm considering moving my B-roll content to Lightroom, but evaluating that option, I want to give Final Cut Pro X a chance to be the only media management software I need. (Besides, I love being able to select a clip in one library, press "Q" to add it to my project, and have it consolidated into my project library automatically.)
Is there a way to increase performance of a library with a lot of clips in it? Is there another solution I should consider that would increase my speed of finding the clips I need? Is there a better overall media management strategy I should consider?