The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
12 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 ...
1
vote
0answers
19 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
101 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 ...
5
votes
2answers
230 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 ...
2
votes
1answer
22 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
40 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
146 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
64 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 ...
7
votes
3answers
235 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
54 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
75 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
152 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
372 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
253 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?
6
votes
2answers
735 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 ...
8
votes
1answer
277 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
56 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
57 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
80 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
1answer
125 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
680 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/ ...
3
votes
1answer
153 views

Bi-directional Map in Apex or best alternative approach

I am using Apex Map structures for fast one-way mapping of data. This works very well, but I ideally want to map backwards using the same map declaration. The obvious way is to iterate the map, but ...
2
votes
1answer
70 views

What are the performance implications or other drawbacks of Dynamic VF Bindings?

I have an abstract class and a couple of descendants of that class. When I do an apex:repeat over a list of instances of the abstract class I can't access anything defined solely in the child classes ...
9
votes
1answer
274 views

How can cache times be controlled in Site.com?

According to the Site.com informational page Site.com leverages a global network of caching servers that deliver content with fewer server hops How can I (or can I at all) set cache times for ...
2
votes
2answers
491 views

SOAP API - getUpdated()/retrieve() vs query()/queryMore()

The Salesforce SOAP API's getUpdated() is designed to return all objects of a given type, inserted or updated within a given timeframe. IDs for updated records will then be returned and the Salesforce ...
3
votes
7answers
2k views

Deployment with Force.com IDE Taking Forever

We're experiencing extremely long deployment times even when deploying single classes using the force.com IDE plugin to eclipse. The deployment takes up to 1 hour yet running all unit tests from the ...
3
votes
1answer
286 views

How can I profile the performance of Salesforce queries?

In my last question ( Implementing a Keyword Search ) , I described some of the complex queries I've been working on in a new app. In determining my approach, I'd like to consider the performance and ...
5
votes
2answers
316 views

Better performance between if-else-else-… vs hardcoded maps

We're doing an integration project where we receive a lot of code values from a webservice.These codes need to be mapped to a user-friendly, translateable text in a visualforce page. We've set up a ...
5
votes
1answer
223 views

Efficient SOQL query using IN binding with JAVA

With APEX if you have a list of Ids like: List<Id> customObjList You can do one efficient SOQL query using the IN keyword. SELECT ID,NAME from SObject WHERE Id IN :customObjList I have to ...
5
votes
1answer
310 views

Site sometimes incredibly slow - Apex code execution sleeps for several seconds - any chance to fix?

We sometimes experience a very slow response of a Sites page. Usually the page renders in less than a second but sometimes it takes 8 or more seconds. When digging into the debug logs I recognized ...
11
votes
2answers
837 views

How to efficiently profile Visualforce components and their controllers?

I have a quite complex Visualforce component (edit grid) that is running to slow (2-4 seconds to display) When I say complex I mean: The Component itself is calling other components Many thousand ...
10
votes
1answer
144 views

Best way to measure SFDC system performance as perceived by the end-users

In order to do proper performance optimization, and hunt the true bottlenecks, we need to know the current performance situation as perceived by the end-users. I.e. as a minimum the duration from the ...
21
votes
2answers
330 views

Similar queries: Better to query twice or process via Apex?

I'm building a Visualforce page in which I want to display two similar (almost identical) lists of the same sObject -- one for objects with an Open status and one for Closed objects. I can think of ...
2
votes
2answers
334 views

Performance of sites and Authenticated Website User Type

I have to develop a "private" auction site based on data already stored in Force.com platform. Develop a site with Authenticated Website User Type is a viable way? I'm worried about perfomance and ...
4
votes
3answers
155 views

When should I start worring about the number of Records on a single object in a SF Org?

Just completing a project that has been deployed into a global SF Org. We have one object in particular that is likely to require a large number of records and is a related list on most pages. At ...
11
votes
1answer
1k views

What are the implications of implementing Database.Stateful?

I've recently implemented a batch apex class that initially did not implement Database.Stateful. After using it for a while as-is I decided to implemente better error handling via a simple Map to ...
2
votes
3answers
232 views

Overcoming Database.com latency

I am working on a rather complex application hosted on Heroku and pulling data from Database.com. Because of the way SOQL works, I usually make a number of calls where I would traditionally have made ...