Explain Session Timeout and Application Timeout in ColdFusion. Discuss advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion.

What are Session Timeout and Application Timeout? Where we have to do this process?

Application Timeout :
-The time span of an application is available before the application times out.

-The default values need to be set by the ColdFusion administrator

Session Timeout:
-The time span of a session is exist before the session times out.

-The default values need to be set in the ColdFusion administrator

What are the advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?

-Stored procedures specifies the database logic on server side code

-They offer performance benefits while pushing application logic on the database side.

-The disadvantage is that, a poorly written stored procedure can hinder the performance of database which causes the development a little more obfuscated.