Questions tagged [performance]
The performance tag has no usage guidance.
301
questions
0
votes
1answer
19 views
Difference between a straight query and a relationship query
I'm trying to understand the performance difference or query execution time between direct SOQL query and relationship query. For example, I need data from Account and User object. sap_id__c is the ...
0
votes
2answers
22 views
Is `event.getParams()` expensive?
If I have to use a param from the event in a loop, is it better to extract the params to a variable before (e.g. const params = event.getParams()), and use that variable instead of calling event....
0
votes
1answer
17 views
Case Assignment Rules running Multiple Times - Negative Impact
I have a bit of an odd question. Is there a negative impact running assignment rules on a Case object on every insert/update? We have a use case where we need to run when the user uses inline edit, ...
0
votes
0answers
15 views
Leading % in SOQL
I have a requirement to use a leading % in my SOQL as below.I know if we use a leading %, it precludes use of indexes.
SELECT Id, RecordType.Name, Name, PersonBirthdate Account WHERE <<FieldName&...
1
vote
1answer
23 views
Improve performance and speed in Lightning Experience [closed]
Recently switching from Classic to Lightining and users started feeling very slow to load the page, does anybody has any pointers what might the case and what to look for in order to make it faster ...
0
votes
0answers
18 views
Debug Logs Cumulative Profiling not matching the actual debug logs
I have applied debug logs on a batch process and noticing some weird behaviour in Debug Logs. For some of the instances of debug log for execute method, I see that each method invocation to batch ...
0
votes
0answers
12 views
Is that possible to use query plan for dynamic SOQL queries?
I know we can verify straightforward SOQL in query plan. Now, I am trying to find a way to use query planner for a dynamic SOQL queries. My SOQL query depends on several Ids (list of Ids) and binding ...
0
votes
1answer
16 views
How the framework knows that the cached data is stale?
I am wondering on how the framework understand that the data is stale when we use the annotation cacheable=true. Will the framework looks for a change in the timestamp of each record?
0
votes
1answer
37 views
Are there API available to measure the flexipage loading time?
There is "Lightning Usage App" and there is "pages" tab, we can view the flexipage performance on that app. But is there any API available for developer to access those performance ...
0
votes
1answer
23 views
Is there a performance difference between Custom Settings vs Custom Objects? [closed]
Specifically, is it faster to query for a single record from a Custom Setting vs a Custom Object? Or is it about equal performance?
1
vote
1answer
51 views
Any way to tell in Salesforce how much CPU a specific Process Builder/Flow is using?
We are running into CPU time limit exceeded errors in Salesforce. The org does have multiple Process Builders/Flows on the Case object. For a particular Case insert operation, I pulled an analysis ...
2
votes
1answer
94 views
How to avoid nested for loop condition for code Optimization?
public void execute(Database.BatchableContext BC, List<FinServ__FinancialAccount__c> scope) {
Set<String> Acc_Numbers = new Set<String>();
Map<String,List<Id>...
2
votes
0answers
33 views
Is this an acceptable Task query performance
I have been investigating a performance issue in a Visualforce page, with the help from Salesforce support. After a couple of months info exchange, the issue is narrowed down to the DB query time on ...
0
votes
0answers
14 views
Method to display the page execution time
Is there a method to display the page execution time? I have a usecase that needs to display page execution time on a lightning component on a partner community portal.
1
vote
1answer
29 views
Static variable + static block initialisation VS static initialisation
In the doc from salesforce, there is the following example.
public class MyClass {
class RGB {
Integer red;
Integer green;
Integer blue;
RGB(Integer red, ...
2
votes
2answers
153 views
Package installation time is getting *drastically* vary, how to optimize it?
We have unlocked packages with CICD enabled. Sometime those package installation takes 5 mins and sometime goes till 30+ mins. Since I know it had been installed in 5 mins, why its getting weird ...
1
vote
1answer
83 views
How to Optimize SOQL Query when I have 15 million Account records?
I have a use case where I am exposing a custom Rest service that would accept phone# as an argument and compare with the five phone# fields on Account and would return the single record matching ...
1
vote
1answer
41 views
Managed packages: monitoring vendor-initiated upgrades
In the past, we've heard from our Salesforce Support team that certain managed packages in our org may be impacting execution times on key transactions. Business teams recently reported these ...
1
vote
1answer
58 views
Does creating a record type worsen DML performance on the object?
If you have an object with no records types versus one with a couple, is performance affected in terms of DML insertion?
I experienced a change in DML performance after creating multiple record types ...
0
votes
1answer
65 views
API Performance Sandbox VS Production
I've built a custom REST API Endpoint in Salesforce that does a simple query, an external ID is passed to it, and the Salesforce ID is returned as JSON - nothing complex.
I have not yet deployed to ...
1
vote
1answer
471 views
Lightning Web Component extremely poor performance
I have a component that is running extremely slow. I'm seeing it at times take upwards of 30 seconds to pull back and process data (roughly 3k records) received via an imperative Apex call. I've ...
0
votes
1answer
103 views
Too many console.log statements decrease performance? [closed]
I am trying to understand if writing too many console.log statements will hinder the lightning component performance. In particular will it affects the loading and rendering time?
please don't close ...
2
votes
2answers
37 views
Performance Implications at Scale for checking if Set Contains Record before Addition?
As we know, a Set is a collection of unique elements (cannot contain duplicates)
While writing some Apex just now, I was inclined to use !SetName.contains(Id) to skip the addition of records if they ...
2
votes
0answers
338 views
LWC Error: appendChild is not a function / Cannot add property innerHTML, object is not extensible
I am trying to add an iframe element to a container div:
<template>
<div class="container" lwc:dom="manual"></div>
</template>
JavaScript:
import { ...
1
vote
1answer
260 views
How to Optimize a Nested For Loop and Avoid CPU Limit Errors
I'm been tasked w/ updating another Developer's code that was running up against governor limits (specifically the Apex CPU limit).
The code in question is fired via the before update trigger on the ...
0
votes
1answer
99 views
Is it possible to access the Salesforce Performance Test as a Customer Community user?
There are a number of users who only have access to our community that are experiencing a lot of issues with slow pages and I want to gauge where the performance problems are coming from (e.g. latency,...
0
votes
2answers
37 views
How to Test the Performance of Rest web services in Salesforce( at the same time there is multi requests), Is there any tool?
lets say if 10 users hitting web service at same time(concurrency),then how we can check performance.
Please share your Ideas
Thanks in Advance..
0
votes
0answers
15 views
Performance of content-based Files/Notes versus the older Attachments/Notes?
We have a Visualforce that supports large numbers of Notes and Attachments (100+) that we have converted to use Content Objects via ContentDocumentLink. But the queries now run much slower.
Are there ...
0
votes
1answer
85 views
Improve performance of a rest resource
I have a rest resource which fetches more than 10000 records. iterates the list using foreach and adds each record to a custom wrapper class list and finally returns the custom wrapper list as ...
0
votes
1answer
62 views
Can Performance Testing possible in a Partial Copy sandbox?
Salesforce suggests Performance Testing only in Full Copy sandbox. Is there any reason why it cant be done in a Partial Copy sandbox?
0
votes
1answer
32 views
Salesforce performance issue receiving “an internal server error has occurred” 933150784 [closed]
I am receiving "an internal server error has occurred" 933150784 when conducting performance testing. This only occurs when the number of users is above 300. No errors if under that amount. Any ideas ...
0
votes
1answer
17 views
Max request per sec/hour for a VF page webform
We have a VF page as a webform and hosted as a Salesforce site.Because there are lot of requests hitting it,is it possible for us to get an estimate of how many requests can it handle per sec/hour?Is ...
3
votes
2answers
54 views
Improving Lightning Performance - What does SFDC consider “Salesforce organization configuration issues”?
Per the following SFDC article, Salesforce indicates four main reasons for Lightning Performance Issues and page load time:
Geographical
Device
Browser
Salesforce organization configuration issues
...
0
votes
1answer
28 views
How to modify two similar queries to optimize my code
I have two queries that are similar except there's a few differences between them. I was wondering if there's a way to optimize this, by querying this once and still do what I want with my code.
The ...
3
votes
0answers
31 views
Are individual object describe calls expensive enough to justify static cache? [duplicate]
Supposing we have a method that executes logic dynamically depending on the SObject type like the following one:
public class TestDescriber {
public static void callMeManyTimes(SObject record) {
...
0
votes
1answer
38 views
Apex Batch slow
I've launched an apex batch but each processed batch is too slow. Looking at the duration of each execute method, I see that the duration is around 2.668 ms but the next execute method is processed ...
4
votes
2answers
451 views
Trigger performance and readability - matching text multiple times
If I was trying to compare a lot of strings, my code is quite easily read (I feel) but I know there is a lot of duplication. Especially when the field values are the same, is there a tidier way of ...
1
vote
1answer
406 views
What is performance gain of using Composite API over Custom Apex REST API?
I want to know whether using Salesforce Composite API will give me any performance gain or not in my scenario. I am not expert in Salesforce and don't know much about Composite API. So, before I move ...
3
votes
1answer
202 views
How can i create a Map for unrelated objects?
Background
We create shadow records for Contacts that are Inactive (record type) and I am working on building a UI for the user to Activate one or more shadow records associated to that Account. ...
0
votes
1answer
37 views
Efficiency issue when rendering custom aura component
We have a custom aura component (see picture) which has to show a list of records from a custom object where the user can select other other records (from other custom objects) which will be ...
13
votes
5answers
2k views
Should trigger handlers be static or non-static?
For a generic trigger, are there circumstances where one of the following patterns is better than the other?
trigger ObjectTrigger on Object (after event) {
ObjectTriggerHandler oth = new ...
0
votes
2answers
48 views
Benefit of actually excluding records with logic directly in Trigger vs. TriggerHandler
Is there any performance benefit of excluding records in logic directly in the trigger to avoid instantiating another class (TriggerHandler) that would essentially do the same thing? I know best ...
1
vote
1answer
45 views
Is it possible to check the time taken by a Salesforce Record to load when we we view/open the record?
Can i find the time taken by my record page to load in Salesforce Dev Console.
4
votes
0answers
62 views
Why is NPSP (Nonprofit Success Pack) dramatically slowing down my code?
I noticed recently in the performance timeline of an Apex test that NPSP is taking an extraordinary amount of time on the database during our tests at mulitple points. (see picture - all highlighted ...
2
votes
1answer
41 views
Can postMessage in doInit with huge dataset cause any memory issues in Chrome?
We have a VF page which has datatable initialized. This VF page is embedded inside an iframe in a lightning component.
For now case records are 200-300, so the page loads quickly as loading of ...
3
votes
1answer
45 views
Does the latest API on classes,triggers,and components provide a performance benefit over older APIs?
My thought is "no", but wanted to see if anyone had any information on this.
I would assume the versions simply control how you can interact with the features in Salesforce (ex. methods you can use, ...
0
votes
1answer
50 views
Which one is the Optimize one when consider in a Batch?
Which one is the best way to optimize the performance if optimization available,
Option 1:
public without sharing class AccountTrigger extends TriggerHandler{
List<Id> accountIds;
public ...
0
votes
0answers
33 views
Does indexing a custom field in the below scenario will help with Non-Selective query error?
Background :
I have a object(Foo__c) with two columns(Value__c, Type__c).
Type__c is a picklist, with two options(A and B) and Value__c
is a text field.
Running into Non-Selective query error when ...
0
votes
1answer
438 views
Lightning console : Crash solution? (Definitely memory leak from inside lightning)
As per documentation :
https://help.salesforce.com/articleView?id=console2_technical_requirements.htm&type=5
We should 8 GB Ram out of which 3GB needs to be allocated to
Salesforce tabs.
...
0
votes
1answer
431 views
can too many validation rules cause a performance issue with large data - Apex CPU Time?
I have a bulk update process which effects updates records in more than one salesforce objects like - Account, Contact, Contract , Opportunity and Oppt Line Item.
This bulk process does not update ...
