Forum Discussion

Moderator

Re: Service Issues?

Hi Paul,

You should definitely put in a case with our Tech Support team and let them know the apps impacted so they can dig into what you are experiencing. They can pull up more performance specifics.

------------------------------
Evan Martinez
------------------------------

4 Replies

PaulPeterson1
Qrew Assistant Captain
4 years ago
The issue was identified to be a formula query field in one app. Whenever I try to save the field every app on the realm goes down for several minutes. The code I used was presented in a workshop in the 2021 Empower. All I changed were the field names and numbers. It worries me that 1 field can take down an entire realm.

------------------------------
Paul Peterson
------------------------------
- MarkShnier__You
  Qrew Legend
  4 years ago
  Formula Queries on large data sets can take down an app. How many records were involved and what was the nature of the Query.
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - PaulPeterson1
    Qrew Assistant Captain
    4 years ago
    I understand the possibility of taking down an APP, but am very concerned that it took down the entire realm. The table being queried has just over 263k records, 43 fields per record, taking up about 18 MB. In the same workshop that presented the code I used they queried a dataset of over 300k records in a fraction of a second.
    
    The query was: SearchAndReplace(ToText(GetFieldValues(GetRecords("{'31'.GT.0}", $tableID), 77)), "> ; <", "><")
    
    The overall function of the field is to generate a dynamic HTML table in a rich text field.
    
    ------------------------------
    Paul Peterson
    ------------------------------