Salesforce.com: Large Data volumes

In LDV cases, first and foremost you should consider options for Data Reduction such as archiving, UI mashups etc.. Where LDV is unavoidable the concept of Selectivity should be applied to the functional areas impacted most.
Data Reduction Considerations:
Archiving :
Consider off-platform archiving solutions
Data Warehouse:
Consider a data warehouse for analytics
Mashups:
Leave data in-situ in external systems and integrate at the UI level
Selectivity Considerations:
Selective
Reduce the number of objects and fields used in a query.
Narrow Range Reporting
Apply selective report filtering.
Filtering:
Apply restrictive filtering to Listviews and SOQL where clauses.
Custom Indexes:
Can be effective where query values in the indexed field represent less than 10% (or <300K) of the overall record count.
Skinny Tables:
Can be effective as a report accelerator at 5M records plus.
SOQL – avoid NULL values (can’t be indexed)
Horizontal partitioning of data :
Split objects by geography for example.
Denormalisation:
To remove expensive joins use Apex Triggers to resolve FK
Divisions:
Acts like a DB partition (by geography, ownership etc.)
Avoid over parenting:
10K limit for child records, per parent record. For example avoid one parent account having more than 10,000 contacts etc.
Data Skew :
look for even distribution.
Loading Data :
Use the Bulk API to load large data volumes, via the Apex Data Loader perhaps (requires setting value to be explicitly set). The Bulk API, in simple terms, uploads the data into temporary tables then executes processing of the data (actual load into target objects) using parallel asynchronous processes. This offers potential performance improvements over the serial and synchronous combined upload+process model employed by all other loading techniques.
Data Loading Considerations;
Defer complex sharing rules
Disable Triggers and Workflow (post-process via Batch Apex)
Speed of operation; Insert then Update then Upsert (involves implicit query)
Group and sequence data to avoid parent record locking
Remember database statistics calculate overnight, wait to do performance testing
Tune the batch size (HTTP keepalives, GZIP compression)
Salesforce Large Data volume Best Practices



Source : http://www.saasanalogy.com/salesforce-com-large-data-volumes/

Comments

Post a Comment

Popular posts from this blog

Custom Calendar on VisualForce Page

Image
There has always been a need to have a calendar component for visualforce page this kind of component can be used in events booking,events calendar,scheduling requirements and all the places where we need to show events by dates. This can be easily implemented using jquery,fullcalendar plugin and json in apex. So what we need here is 1.) Fullcalandar plugin  Download 2.) A custom object with start dates and end dates for events 3.) Apex class to pull data from object and convert that into json using json.serailze First we have to upload the fullcalendar lib to static resource and then we have to create a visualforce page with below code. The important thing is "JSONOFLIST" which is just json created from list of records by using JSONOFLIST = JSON.serialize(LIST OF SOBJECT); It will give you a calendar with items highlited on page Source : http://www.saasanalogy.com/custom-calendar-on-visualforce-page/
Read more

Salesforce.com: Expression Operators in Salesforce lightning Components

Image
Generally In every component implementation we have a need to  change the UI conditionally, or show/hide a section/column based on certain conditions. We need simple ways to do this instead of having every handler in code. Below are key operators and their syntax to handle any such situation Ternary Operator This expression uses the ternary operator to conditionally output one of two values dependent on a condition. 1 <a class="{!v.location == '/active' ? 'selected' : ''}" href="#/active">Active</a> The {!v.location == ‘/active’ ? ‘selected’ : ”} expression conditionally sets the class attribute of an HTML <a> tag, by checking whether the location attribute is set to /active . If true, the expression sets class to selected . Using <aura:if> for Conditional Markup <aura:attribute name="edit" type="Boolean" default="true"/> <aura:if isTrue=...
Read more

Salesforce.com: Scheduled Apex

The Apex Scheduler lets you delay execution so that you can run Apex classes at a specified time. This is ideal for daily or weekly maintenance tasks using Batch Apex. To take advantage of the scheduler, write an Apex class that implements the Schedulable interface, and then schedule it for execution on a specific schedule. Scheduled Apex Syntax To invoke Apex classes to run at specific times, first implement the Schedulable interface for the class. Then, schedule an instance of the class to run at a specific time using the System.schedule method. global class SomeClass implements Schedulable { global void execute(SchedulableContext ctx) { // awesome code here } } The class implements the Schedulable interface and must implement the only method that this interface contains, which is the execute method. The parameter of this method is a SchedulableContext object. After a class has been scheduled, a CronTrigger object is created that represents the scheduled job. It p...
Read more