Calculating SOQLs when SFM search is cloned/created
SFM search configuration is a powerful tool using which you can create and customize the Search feature. When you create or clone a Search configuration, a definite number of SOQLs get consumed in this operation on save. The details of the SOQL consumption are listed in the table below.
|
Number of Objects Used in the Search Configuration
|
#SOQLs (q)
|
# DMLs (p)
|
|---|---|---|
|
n
|
q = (n*5)+5
|
p = 5 + 3(n-1)
|
|
3
|
20
|
11
|
|
2
|
15
|
8
|
|
1
|
10
|
5
|
 |
The objects used could be the same or different.
The other criteria like the number of Search expressions, number of Display columns, and so on do not contribute explicitly to SOQLs. It is advisable to keep the number of objects used in search configuration under 15.
|