Table of Contents
- Introduction
- Performance suggestions on project compilation and deployment
- Performance suggestions on loading installable cloud apps for the first time
- Performance suggestions on running installable cloud apps
-
- Debugging the performance
- Adjusting the log level
- Working against the impact of Internet and slow networks on runtime performance
- Hosting Web APIs and database on the same LAN
- Web API publishing method
- Optimizing database server performance
- Tuning excessive server calls
-
- Overview
- Technique #1: grouping multiple server calls with PowerServerLabel
- Technique #2: partitioning transactions via stored procedures
- Technique #3: partitioning non-visual logic via server-side REST APIs
- Technique #4: eliminating recursive embedded SQLs
- Technique #5: eliminating DW computed fields calling user functions that have ESQL
- Minimizing large data transmissions
