The processing time can be improved if you can [delegate these functions](https://community.denodo.com/kb/en/view/document/Scalar%20functions%20list%20in%20a%20data%20source) to the source. Please check in your execution trace if these functions are delegated to the source. For this, click the bottom node associated with the data source. After selecting the node, on the right side of the execution trace, you will see Properties and Advanced Properties which you could expand using the ‘+’ symbol. These properties show you information about the connection, including the query sent to the database next to the ‘SQLSentence’ label.
You can check these functions on the Virtual DataPort Administration tool by navigating to the Source configuration option under the Configuration tab of the datasource. Under the option ‘Delegate Scalar Functions list’, you can find the list of functions that can be delegated to your data source. The functions that are delegated vary from one database to another. Further, you can also use a CONTEXT clause to set the Query Timeout argument. For example,
`SELECT * FROM <view_name> CONTEXT (‘QUERYTIMEOUT’=’900000’);`
Hope this helps!