The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
3answers
41 views

Need help in improving SOQL performance

I have a SOQL query as below (where clause only). This query is not performing upto the mark, may be because of like operator. How can I substitute this :- Where ( abc__c = 'chris' OR xyz__c = ...
0
votes
1answer
26 views

Why is my report taking forever to run?

When working with a very large dataset of Accounts, e.g., 10's of millions of records, I wanted to create a report to return a subsets of records, i.e., records filtered by country. I created a ...
1
vote
1answer
16 views

Track number of API calls for an application

I'm working on an application, which uses SOAP, REST and Bulk API to integrate with Salesforce. Is there any API call in Salesforce which enables me to track how much API calls did I consume in a ...
3
votes
1answer
47 views

SFDC European Data Center experiences

I see a new EU5 instance on trust.salesforce.com which has a 'LON' hovertext over it, assumingly referring to London. I can imagine some companies might be interested in having their data hosted in ...
2
votes
1answer
22 views

No response to compile request in MavensMate this morning

This morning when compiling classes to server in one of my sandboxes, the files are "spinning" forever in MM's status window. But if I open the classes list in the browser, I can see that the ...
6
votes
2answers
101 views

Best practises for speeding up Apex Batch class

My previous question about slow Batches probably was to focused on a specific problem, so I try it again much broader. What are general rules of thumb to make a slow Batch faster? Although I added 2 ...
5
votes
2answers
144 views

Only query Id field in start() to speed up Apex Batch

I am looking for ways to speed up a complex Batch job which takes days to run in a specific customer org. This Batch is snapshoting records of arbitrary objects into denormalized (as a single records ...
2
votes
0answers
38 views

Reports API - Slow Down

Team, I wrote the below class on Thursday and it was working like a dream (1 - 2 seconds to load the page). Now, on Saturday when there have been no changes to the code since Thursday it take 15 - ...
2
votes
3answers
51 views

Do big classes reduce performance?

I have a big (right now it's 1,4k lines) 'toolbox' class. I have a lot of static methods and wrappers there which are used in various number of services or manager/handler classes. Does anyone notice ...
1
vote
0answers
27 views

reduced latency and improved transaction speed since new data centre opens

I wonder if there is a direct reduction in transaction time for EU based customers as a result of the new data centre that opened in the UK last week (w/c 27th Oct '14), we have noticed a reduction in ...
2
votes
1answer
39 views

Performance impact of relationship queries in batch start

For a new batch process I have a choice between immediately selecting relevant records in the start function (but using several [field]__r comparisons as they are junction objects being queried) or ...
0
votes
0answers
16 views

For SF performance testing What is LR protocol recomended

Using Loadrunner Tool, to execute Performance test on SFDC. What will be the best protocol to use to develop the LR scripts.
0
votes
0answers
40 views

Can you please advise on REST API best practices in terms of batching the amount of rows per call, when adding to a data extension?

Can you please advise on REST API best practices in terms of batching the amount of rows per call, when adding to a data extension? One of our clients tried inserting data in batches of 50 records as ...
3
votes
2answers
57 views

What is the importance of Heap size limit?

I don't understand the importance of heap size limit of 6MB. So could someone help me understand the heap size limit?
2
votes
0answers
36 views

Having a Visualforce page inside of a standard page results in duplicate main.js

I have a custom Visualforce page rendered inside of a standard page Opportunity in one of my layouts. I was researching some performance issues when I noticed that 2 main.js files are travelling down ...
3
votes
2answers
144 views

Any reason not to monitor ALL event types (operations) in triggers

Is there any drawback on having defined all possible Trigger events / operation before x, after x, before y, after y in the header of a trigger even if I don't use them in my code? As most decent ...
0
votes
1answer
72 views

Check if the value was changed in the original object in a trigger

I'm writing a rollup trigger to update a field at account level based on some criteria. Let's say there's a boolean field with true/ false values. Should I check if the value has changed at original ...
1
vote
1answer
31 views

Performance Test SF on IPad

i need your help and support on an important topic. We have build on SF a new sales solution which will go live within the next months. Every morning I have a data synchronisation on the IPad. So data ...
3
votes
0answers
83 views

How to load Chatter by Javascript

Question How could I load chatter (chatter:feedWithFollowers) dynamically (by javascript) in the browser? Motivation I'm working in a visualforce page that has the requirement of load as faster as ...
3
votes
1answer
48 views

VF Performance Issue

Salesforce recently notified us that "a VF is consuming high levels of DB resources due to inefficient SOQL in your VF controller." I believe I have identified the issue down to this query: ...
2
votes
1answer
49 views

Speedup Testing with Force.com IDE using slim Logs - but how to set the log-level?

A lot has been written here about slow development in general and slow testing in particular e. g.: Slow development Faster unit tests? For my use case I found one reason for slow testing while ...
4
votes
2answers
177 views

Concurrent HTTP callouts vs single callout

Background I have 3 identical HTTP servers, holding the same data: api1, api2 and api3. I want to query this data as reliable and quick as possible. In Java, I would have done this by spawning 3 ...
2
votes
1answer
137 views

renderAs CSV (10K+ rows): What are the best practices available to avoid hitting Apex cpu time limit exceeded limits?

I am trying to download a CSV using render as attribute in apex:page. The output data that is rendered is the real-time response from a callout from salesforce to SAP webservice. The number of records ...
4
votes
2answers
421 views

Performance difference between Sandbox and Production instances?

I am seeing little bit difference in the page response time in sandbox and production org's. Actually, i am thinking the production org instance is faster than the sandbox instance because it might be ...
2
votes
1answer
143 views

What is the use of calling a controller inside an APEX trigger? Is that a best practice?

I saw some posts related to APEX triggers and recently one below, Salesforce method to update doesn't get commited in which the trigger have few lines, ApexPAges.StandardController sc = new ...
14
votes
3answers
529 views

Writing too much to debug log would affect APEX trigger or Visualforce page performance?

In order to debug we usually write chunks of data to the debug log using System.debug statements. Will writing too many debug logs affect visualforce page or Apex performance in any way?
2
votes
2answers
111 views

Salesforce webservice performance

I am using Partner WSDL to get data from salesforce, To do it I am using those steps: 1. Getting the object list: sforceService.describeGlobal() Getting the table field ...
10
votes
3answers
361 views

Measuring performance of batch apex query

Is there a good way to tell how long the query in a batch apex job is taking? I don't find anything in the debug logs. I can see each batch and how long it takes, but not how long the initial query ...
2
votes
1answer
191 views

How to measure inline visualforce page(s) performance and load time when it is pinned in a standard page?

i have enabled development mode and want to verify the Performance tree, view state, etc. Since i have a inline visualforce page i am not seeing a development mode window displayed on my Account ...
1
vote
1answer
42 views

Counting account totals within another account type

In our Salesforce deployment, we have two account types (partner and merchant). Merchants have a custom field that contains their parent "partner" account. I am trying to write a trigger (on ...
2
votes
0answers
107 views

How to test SOQL Query performance for Communities User

I am experiencing performance issues on my Production instance with SOQL queries being executed by a Communities user. I'd like to finetune the SOQL Query performance and have done some tests in the ...
4
votes
3answers
143 views

The backup solution (for system disruption / non-data backup)

We have encountered several performance impacts in the last few weeks. Although, the root-cause is reported in the trust.salesforce.com, the risk still exists and the service disruption can happen in ...
6
votes
2answers
1k views

Contacts without Accounts: Is it possible, and if not, why?

Context: My understanding is that historically Salesforce was built to manage Business-to-Business (B2B) contacts, and the idea that the data model would not be built for contacts without accounts ...
4
votes
1answer
46 views

Org Assessment - Tools

We are planning to do an org assessment. Background: We have a huge org (especially Case objects - Lot of workflows, lot of triggers) we almost reached limits. (Millions of records in Case object; ...
1
vote
2answers
156 views

How Salesforce Performance varies when Multiple Validation Rules Triggers for Bulk Records

We are Implementing Data Validation Process for our Organization for which we are thinking to implement following techniques: Apply validation rules for every object in order to maintain Data ...
4
votes
2answers
168 views

Should I wrap multiple getters into a Map

I have a VF Controller class with several instance of a wrapper class - something like this: public Transient mywrapperclass wrapper1 {get;set;} public Transient mywrapperclass wrapper2 {get;set;} ...
1
vote
2answers
452 views

Apex test is slow during deployment, but fast any other time

I have a test that takes about 5 minutes to run during production deployment. If you just click "run test" or run it from execute anonymous, it's not slow at all (a few seconds). Is there a way to ...
8
votes
3answers
1k views

What are Apex Performance Best Practices?

Is there a definitive guide somewhere that outlines the best practices for faster executing code? I am looking for specifics, like Adding elements to a Set versus to a Map Testing for null before ...
3
votes
1answer
97 views

Performance comparison - repeat loop vs more in one loop

I'm trying to optimize some code and am going through some triggers. I'm wondering if there is a performance difference between running three methods in series - and in each one, I loop over ...
7
votes
1answer
111 views

Measure (SOAP) API call performances

Is there a way to measure SF server processing time for specific (SOAP) API method call? Example: I am invoking update of 200 objects in one request. I would like to see SF processing time on their ...
2
votes
1answer
321 views

considerations re: performance and servlet.integration?

I'm assuming that servlet.integration represents the loading and launching of an apex program (VF, Controllers and all) into a java servlet runner. It appears to take a long time for the first apex ...
2
votes
2answers
836 views

SOQL Count() Vs Query data which is more faster?

If you want to check if there is record of ProcessInstance exists in the system or not, please suggest which one of the following approch is faster and best practice to use ? Approch 1 - Query Object ...
3
votes
3answers
459 views

Could debug logs slow down the application?

In my apex applications i have tons of the System.debug('...') outputs. Should i remove it all for the production use? What is the best practice for this?
7
votes
2answers
2k views

Advice on speeding up Visualforce pages?

I have a fairly complex Visualforce page that displays about 10 fields from about 10 different custom object types including a couple of tables, making about 20 objects overall in total (i.e. 200 ...
9
votes
1answer
658 views

Are formula fields so inefficient?

I'm working with some colleagues on a project which the clients would like optimized, as they feels some things are too slow. One of my colleagues has suggested that we should cut down on the use of ...
3
votes
1answer
79 views

Will GROUP BY run faster if grouped field has a Standard / Custom Index?

Would it help to make a field an External Id if we use it as a GROUP BY field in many LDV SOQL queries? Is there a order in which SOQL queries are processed? So will it group after it filtered? How ...
1
vote
0answers
108 views

Why does this Batch always and only abort in Production?

I have a long running asynchronous process that process millons of records in a CustomObject__c. To prevent other limits we have split this into 2 Batch classes that work on this table in parallel. So ...
1
vote
2answers
166 views

Why do batches behave different in Production than in a Sandbox

Recently I observed serious and undocumented differences in the runtime behaviour of Sandbox vs. Production orgs, e.g.: Batches (same code, same data) run faster in the Sandbox Same Batch in Sandbox ...
2
votes
2answers
226 views

Make an existing text field an indexed External Id. Will/can Support do it?

In our ISV package we had to "convert" a pre-indexed Lookup field to a Text(255) field as we wanted to keep Ids even when the referenced record was deleted. After we did that the performance of SOQL ...
4
votes
2answers
1k views

Performance Testing best practices/suggestions/recommendations

I have an understanding that Salesforce itself does its own sets of internal Performance Testing. However, there are companies who have a mandate to perform Performance Testing as one of their tasks/ ...