Any way of timing a functions or speed up processing

[leok31]

I building a front end UI for SQL Server. Im trying to figure out why certain functions are taking long to process. I know that Im running a lot of functions, but I want to know if there was any way to speed things up.

For example, one button will launch 20 functions whose results will be allocated to a textbox on the form.
There are also some calculations being done on the fly and connecting to SQL Server via stored procedure.

Is there anything like that?

 

[Galaxiom]

If the functions are custom in the Access FE or are standard but with no equivalent in SQL Server the data will need to be brought across to the FE for processing.

If the select criteria are based on those functions then the entire table of records may need to be processed by the FE.