Forum Discussion
Helper Ioptimization of notebook taking data from salesforce
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
Helper IMostly memory and capacity utilization
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