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.
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.
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 Force.com's asynchronous processing engine.
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.
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 […]
The Force.com 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 Force.com 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.
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.
Join us for a live webinar on October 16 and learn about your event notification options on the Force.com platform. This intermediate-level webinar will introduce a variety of requirements around event notification, and we'll compare and contrast Force.com 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 Force.com Streaming API.
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 Force.com 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.
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 salesforce.com cloud solutions with your assets.