Forum Discussion
ivannye
Helper I
1 year agooptimization of notebook taking data from salesforce
Hi Guys, I would like to optimize this query. It run every 5 minutes but it takes a lot of ressources. I would appreciate any help to optimize it please. Edit: I deleted the code as I have found...
- Anonymous1 year ago
HI ivannye,
It seems like you are handling query data from data base that only applied one filter by datetime and return with many columns.
Have you tried to limit the result row numbers such as pagination effect or only execute one simple query each time? They should reduce the resource usages.
Also you can try to only return the key field ID list from table, then you can use these IDs as condition to filter records to return the table with wanted fields.
Regards,
Xiaoxin Sheng
lbendlin
Super User
1 year agoPlease be more specific. Which part of the process takes the longest time, and what are "resources" ? Memory? API calls?