steve-bobrowski's Blog Posts

Know Thy Salesforce Field Indexes for Fast Reports, List Views, and SOQL

Salesforce field indexes

Creating selective, optimizable filter conditions that target indexed fields is key when you want to run fast Salesforce reports, list views, and SOQL queries. But how do you know which fields in your database have indexes? Read this short blog post to learn the easiest way to identify both standard and custom fields that have the indexes.

Salesforce Anti-Patterns: A Cautionary Tale

Salesforce anti-patterns and worst practices

Don't let your Salesforce org suffer from anti-patterns that often emerge unknowingly as you customize your business needs. Read this fun fictitious story to learn how to avoid and recover from sub-optimal implementations.

4 Steps to Successful Asynchronous Processing with Asynchronous Processing

A manufacturing plant's management teams coordinate to schedule maintenance work when the plant is shut down. Why? So that nothing interrupts the efficiency and production output of well-tuned assembly lines. Similarly, you need to carefully consider asynchronous bulk job efficiency and scheduling in your Salesforce org so that users remain productive processing transactions during normal work hours. This post covers four of the most important things to remember when using's asynchronous processing engine.

Salesforce Bulk Data Loads and Full-Text Search Indexes

Salesforce Data Bulk APIs

Quickly loading large amounts of data into the Salesforce1 Platform is certainly awesome, but can temporarily cause stale full-text search indexes. Do you understand why this can happen? More importantly, do you know why this matters to your application users and strategies for addressing this problem? Read this post for more details.

How Much Data Can You Load into Salesforce in One Hour?

Fast parallel data loading with the Bulk API

If you’ve read the many blog posts, wikis, webinars, and other content from the Customer Centric Engineering-Technical Enablement team, then you already know how we help customers investigate and solve challenging problems, take what we learn, and teach others how to avoid similar problems. The idea is to make tough roads easier to travel for […] Query Optimizer Secrets You Can Use Today

The Query Optimizer

The query optimizer is not unlike the cost-based optimizer you'll find in many traditional relational database systems--it helps map out the most efficient path to the data you request from the database. However, because the database is multitenant and uses a record-ownership model, it has some remarkable differences to be aware of so that you get the best performance for your applications.

Under the Hood: How the Salesforce Platform Handles 1.3+ Billion Transactions per Day

Salesforce Platform 1.3+ Billion Transactions

Open the hood, have a peek, and learn more about how the Salesforce platform is built to handle more than 1.3 billion transactions per day.

Alert! Salesforce Event Notification Webinar on October 16

Alert! Salesforce Event Notification Webinar on October 16

Join us for a live webinar on October 16 and learn about your event notification options on the platform. This intermediate-level webinar will introduce a variety of requirements around event notification, and we'll compare and contrast features you can use to meet those requirements. Topics include point/click approaches with Chatter, workflow rules, and scheduled reports, as well as programmatic solutions built on Visualforce and the Streaming API.

Collecting Selectivity Statistics for Queries

Collecting selectivity statistics

Building efficient SOQL queries, reports, and list views depends on selectivity and indexes, especially when your objects have some serious record counts. Previous resources teach you how the query optimizer makes decisions, including information about selectivity thresholds for filter conditions. But how can you put this knowledge into practice? This post gives you some simple, practical steps for gauging the selectivity of your filter conditions--before you actually use those conditions in your queries.

Your Data in the Cloud: Salesforce Security, Privacy, and Trust

Your Data in the Cloud: Salesforce Security, Privacy, and Trust

It’s important that you are confident that your cloud provider has the world-class security and privacy solutions to adequately protect your data. So what does it take to trust a cloud? Read on to learn why you should trust cloud solutions with your assets.