Forum Discussion

ivannye's avatar
ivannye
Icon for Helper I rankHelper I
1 year ago
Solved

optimization 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...
  • Anonymous's avatar
    Anonymous
    1 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