I've got a code, where on lead insert, I also insert 1 record of custom object Demand_Funnel__c. Demand_Funnel__c has no apex triggers, no WF rules, no Processes tied on it. If it's a first lead insertion of the day, Demand_Funnel__c insertion could take up to 6 seconds.
All subsequent insertions take 0.1-0.2 secs.
Additional info about enviroment/object: Object has ~1.5 million of records. Object has 260 custom fields and 12 custom relationship fields. Org itself has tens of millions of records.
I've only found this post with similar issue with no answer.
Does anybody know, why simple insertion can take up to 6 seconds on first insertion of the day?