Can you use static variables to store queried information and improve performance?
Anonymous
Me: "Static variables don’t retain their values between transactions. I prefer to use Platform Cache for this purpose though if the object is greater than 100kb you'll need to break it up into chunks. This is what I'm currently doing in our org." Him: "No, I don't like that. Platform cache is only retained for 15 minutes." Me: "I guess it can be more complex than static variables..." (Platform Cache is retained for 48 hours but I didn't want to argue.)
Check out your Company Bowl for anonymous work chats.