The best way to use Catalogues is to learn how to ignore them. I think LR does a rather decent job on a limited number of images. Then it slows down.
I have just recently taken on LR for cataloging, and at 180K images it does show how it slows down. Even though the catalog is about 2GB, it is a bit slow to work with.
I am dealing with it for now. I run Quad-3.6Ghz/16GB ram with SSD's, and Win7-64bit. The catalogue size is taxing on LR. Can I throw more HW at it, sure. Will it do much good? I don't know exactly. Yes, able to work, but, you just feel this sense of "catchup" of split seconds before it reacts. And doing that with the tool set it has, is a bit frustrating.
I have always advised against using a "All-in-One " solution. As we all know they may do the juggling act just fine for some, but there is threshold it reaches. Take for example an All-InOne printer. It will Fax just fine, and print a few sheets and scan some things just FINE...But try and scan something for substance. Try printing 50 or 100 sheets. There will be something that gives. Can you wait for 100 pages on a low volume printer? How much of the ink will that print job take up? Can you accept a scanner at 1200dpi interpolated resolution with what dmax? Can you do with half duplex faxing? If it does handle these...at the least it will be slow at some point, and cost you. I am getting at the edge of that point. I still have another 200K images I'm "supposed" to include in the 1 catalogue methodology! That will be about 400K images of my 20 years in image making. I do think LR is impressive, and does a lot of things well. But for a long time user to gain from the features it promises; mainly the organization of an all inclusive catalog system (it must do this as everything else it is blind to the catalog), you have to use 1 large catalog. Unless it finds a way in the future to separate itself from Developer and Dam/Cataloguer....It will crawl to a halt. But I'm sure Adobe is hoping the HW upgrades will stretch you over in this bottle neck....There is little chance at this due to the reaction speed from the catalogue instructions to the NAS and back to your screen. If you know otherwise, I'm all ears.
For C1, I have lost hope on their methods of approaching files in the first place. They had it right up until they started to force Sessions. Now its just an anoyance I work around as much as I can, but it leaves you the feeling of simply avoiding the software. This is rather the saddest thing for me, as I actual LOVE C1, and its abilities. It just uses a backwards approach to accessing or even creating files. Sad, but it is true, and the MAJORITY of how the users feel. But they have the reputation and plenty of new sheep to enroll into the method, until some realize it just simply isn't working for them. The more you know about how your files are and how you like creating them, the more it frustrates a person. I do wish they would do 3 things ..and it would solve all this.