We have a very large system doing a complicated business process. On account creation we are creating many dozens of custom objects and on the latest release today we have hit the wall of 101 queries and (maybe!?) today we can optimize a bit more to get under the limit but soon we will not be able to further optimize the queries.
This is due to large functionality increase. Assume our entire team has done the work perfectly (putting no SOQL querys in a loop and everything is done via Hashmaps and List selects etc.), does anyone have a brilliant way to break up the stack or to reduce the total number of queries?
My first thought is to split it in two so we can do 50 and 70 for example? Since we are clearly like 120 currently.
Has anyone else hit this problem? Has Sales-force worked with you to move this limit for a large system?
One Hack I was thinking of was along the lines of changing something in the front-end so it can send a second data create for a round 2. I would not bother the user at all but maybe we can play with the page to break it up and cause a second process to trigger.