Slow loading skuid page

  • 3
  • Problem
  • Updated 6 years ago
  • Acknowledged
I have a Skuid page that always loads without an issue for me. However, I have a user that has trouble trying to load it. Sometimes they get an error that says Time Limit has been Exceeded and other times it loads after about 15-30 seconds. How can I troubleshoot this issue and determine the root cause?

Photo of Peter Herzog

Peter Herzog

  • 1,704 Points 1k badge 2x thumb

Posted 6 years ago

  • 3
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 45,188 Points 20k badge 2x thumb
If there is a differene in performance between users of the same Skuid pages,  Its almost always going to be caused by factors external to the Skuid page and Salesforce.  Its going to be the network connection,  the computer speed, etc. 

If you are getting similar problems accross all users,  then you can start working on optimizing your data connections with Salesforce.  That is usually the culprit.  Here are a few key things we've discovered  when dealing with Models on objects with 100k+ records (under that, it doesn't matter much):
1. Try to filter on at least one Primary or Foreign Key field, e.g. on AccountId, WhoId, WhatId, MyLookup__c.   Always filter on at least one indexed field.

2. Don't use "negative" operators --- e.g. "!=", "not in", "excludes", "does not contain", etc.

3. For queries on Tasks, try to always filter on CreatedDate or SystemModStamp, rather than on ActivityDate, as ActivityDate is not indexed.

I hope this helps.