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...

New Components The following components are new and require API version 42.0 and later. lightning:carousel (Beta) A collection of images that are displayed horizontally one at a time. lightning:formattedAddress Displays a formatted address that provides a link to the given location on Google Maps. lightning:formattedName Displays a formatted name that can include a salutation and suffix. lightning:formattedTime Displays a formatted time based on the user’s locale. lightning:inputAddress Represents an address compound field with support for street, city, province, postal code, and country. lightning:inputField An editable field with a label, help text, and value that corresponds to a field on a Salesforce object. This component must be nested in a  lightning:recordEditForm  component. lightning:inputName Represents a name compound field with support for salutation, first name, middle name, last name, informal name, and suff...