Being A Programmer

This article comprises the FAQs related to salesforce internal platform Query Optimizer.and provides valuable information that will help understand how to improve the performance of SOQL queries. For more information, you may also check this Dreamforce Session . 1. Query Optimizer Q: Does Salesforce have its own SQL optimization logic instead of Oracle's built-in? A: Force.com is a multi-tenant platform. To consider multitenant statistics, the platform has its own SOQL query optimizer that determines optimal SQL to satisfy a specific tenant's request. Q: How frequently generated are the statistics used by the query optimizer? A: Statistics are gathered weekly. Where statistics are not calculated, the optimizer also performs dynamic pre-queries, whose results are cached for 1 hour Q: Is there any way to flush the cache when doing your performance testing so your results are not cached biased? A: Unfortunately not. Queries with selective filters will perform mor...

It only feels like only yesterday Winter ’18 graced our Org’s, but its time to prepare for another release! The Spring ’18  release notes  were published, and are full of some great features that were showcased at Dreamforce, as well as some pleasant surprises. There is so much fantastic content contained in the Spring ’18 release, expect to see multiple blog posts covering some of the features in more detail. Without further ado, here are 5 features that are really going to change the way you work with Salesforce. 1. Custom Themes The ability to customise the look and feel of Salesforce has never really been available (Apart from attempting to get your logo under 20kb to upload to documents!). From Spring ’18 the age of bland Orgs ends. Showcased at Dreamforce, the ability to completely customise the colours of your Lightning Application is here, you can look to change.. Brand image Brand colours Page background image Default Avatar image Salesfo...