Home
Appeon Web
|
Appeon Mobile
Appeon for PowerBuilder Online Help
JavaScript is disabled on your browser. Please enable JavaScript to enjoy all the features of this site.
Home
Appeon Web
|
Appeon Mobile
Appeon for PowerBuilder Online Help
Appeon Performance Tuning Guide
Tuning: Large Data Transmissions
Sidebar
Prev
|
Up
|
Next
Download PDF
View Knowledge Base
Technique #1: retrieving data incrementally
For Oracle database server
For all other database servers
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
Appeon Developer performance settings
Appeon Enterprise Manager 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
SAP EAServer
JVM startup option
Configuring data sources
JDBC driver used by EAServer data source
Configuring the cache size
HTTP properties
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
Appeon Performance Analyzer
Getting Started
Enabling Appeon Performance Analyzer
Starting Appeon Performance Analyzer
Getting to know Appeon Performance Analyzer
Removing Appeon Performance Analyzer
Working with Appeon Performance Analyzer
System Configuration
Calls Analysis
JavaScript Calls Analysis
ActiveX Calls Analysis
Remote Procedure Calls Analysis
Download Analysis
View Detail
Additional Functions
Filter function
Find function
Save As XML function
New Root Item function
Analyzing log files
Analyzing Windows application log files
Analyzing Appeon Server 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
Index
Search Highlighter (On/Off)
Appeon Web| Appeon MobileAppeon for PowerBuilder Online Help
