We have a pretty complex trigger suite on our org. We've built a lot of custom functionality. I'm starting to worry about governor limits and not really understanding how to manage them. I've read through http://wiki.developerforce.com/page/Apex_Code_Best_Practices and I've made all my triggers accordingly, using as few SOQL and DML statements as possible, querying the database only when I have to and getting all the records I need at once, etc.
What I can't figure out is - what if I just need to exceed the governor limit? What if I need to update 4,000 records when a certain other record they're all related to changes? Am I out of luck? Is SalesForce really viable with large data sets?
Right now my client wants to update 20 different Product records, which could potentially update as many as 46,061 related opportunity line item records. They want a trigger that will update every related opportunity line item, which then will fire triggers that update other custom objects related to the opportunity line items - it multiplies fast, and hits governor limits hard. I'm not sure how to implement @future methods, but even then, those have limits that I'm not sure if I'll hit or not.
What do I do?