Home
PowerServer Web
| PowerServer Mobile
Appeon Documentation Center
JavaScript is disabled on your browser. Please enable JavaScript to enjoy all the features of this site.
Home
PowerServer Web
| PowerServer Mobile
Appeon Documentation Center
PowerServer Performance Tuning Guide
Performance-Related Settings
Sidebar
Prev
|
Up
|
Next
| Download PDF
Database performance settings
Recommended database driver
Recommended database setting
Contents
Search
Appeon Performance
Impacts to Appeon performance
Impact of the Internet and slow networks
Impact of heavy client-side logic
Impact of large data transmission
Expected performance level
Automatic performance boosting
Performance-Related Settings
Overview
PowerServer Toolkit performance settings
AEM performance settings
Timeout settings
Session Timeout Detection Interval
Transaction Timeout Detection Interval
Session timeout
Transaction timeout
Rollback Completion time
Maximum Rollback Retries
DataWindow data caching
Multi-thread download settings
Custom Libraries download settings
Log file settings
Internet Explorer performance settings
Web and application server performance settings
Microsoft IIS server
Recommendations for avoiding common errors on IIS
Advanced thread settings
maxWorkerThreads and maxIoThreads
minWorkerThreads
minFreeThreads and minLocalRequestFreeThreads
maxconnection
execution Timeout
Recommended thread settings
Database performance settings
Recommended database driver
Recommended database setting
Command Timeout
Identifying Performance Bottlenecks
Overview
Analyzing log files
Analyzing Windows application log files
Analyzing PowerServer log files
Analyzing active transaction log
Identifying Performance Bottlenecks of Web Server and Application Server
Identifying Performance Bottlenecks of DB Server
Deadlock analysis
Identifying Performance Bottlenecks of PB application
Analyzing performance bottlenecks of PB application
Tuning: DB Server
Database
Tuning: Excessive Server Calls
Overview
Technique #1: partitioning transactions via stored procedures
Technique #2: partitioning non-visual logic via NVOs
Technique #3: eliminating recursive Embedded SQL
Technique #4: grouping multiple server calls with Appeon Labels
Tuning: Heavy Client
Overview
Technique #1: thin-out heavy Windows
Technique #2: thin-out heavy UI logic
Manipulating the UI in loops
Triggering events repeatedly
Performing single repetitive tasks
Initializing heavy tabs
Using ShareData or RowsCopy/RowsMove for data synchronization
Using computed fields
Using DataWindow expressions
Using complex filters
Using RowsFocusChanging/RowsFocusChanged events
Technique #3: offload heavy non-visual logic
Tuning: Large Data Transmissions
Overview
Technique #1: retrieving data incrementally
For Oracle database server
For all other database servers
Technique #2: minimizing excessive number of columns
Conclusion
Search Highlighter (On/Off)
PowerServer Web | PowerServer MobileAppeon Documentation Center
