Lightroom Classic's catalog system is a relic and i'm tired of pretending it works

i've been a Lightroom Classic user for 9 years. wedding and portrait photographer. my catalog has about 340,000 images. and i'm increasingly frustrated with how the software handles this volume.

the catalog system is fundamentally a design from 2007. it stores all your edits, keywords, and metadata in a single database file. when that file gets large, everything slows down. opening the catalog takes 30 seconds. searching takes 8-10 seconds. building smart collections has become a ""go make coffee"" activity.

but the performance isn't even the worst part. the worst part is the fragility. corrupt your catalog file and you lose all your edits. all of them. i know because it happened to me in 2022 and my backup was 3 weeks old. i lost edits on 4 client galleries. the recovery took a full weekend and some galleries had to be re-edited from scratch.

Adobe's answer is Lightroom CC, the cloud version, which loses half the features and requires uploading everything to their servers. my 12TB library would cost a fortune to store in Adobe's cloud and i don't trust them with it.

what i actually did:

i still use Lightroom Classic for editing because the adjustment tools and presets are genuinely best-in-class. but i changed everything around it.

Photo Mechanic for culling and ingestion. opens a card and displays thumbnails instantly. Lightroom takes 2-3 minutes to build previews. for a wedding with 4,000 images, this saves about 45 minutes per job.

Backblaze for continuous cloud backup of the catalog file and all raw files. if the catalog corrupts again, i lose hours not weeks.

Google Drive for client gallery delivery.

Willow Voice for shoot notes. at every wedding i capture reception details, family group shot confirmations, and lighting setup notes between events. those transcripts are my reference during culling when every photo starts blurring together.

i know Capture One is the ""real"" alternative and i've tried it. the editing is comparable but Lightroom muscle memory runs deep. maybe next year.

what's your Lightroom frustration level? has anyone fully switched to Capture One and not looked back?