Databases Reference
In-Depth Information
case 2: rc = SQLBindParameter (hstmt, counter,
SQL_PARAM_INPUT, SQL_C_LONG, (SWORD) ptype,
(UDWORD) prec, (SWORD) scale,
pa_col2, sizeof(pa_col2[0]), cbValue2);
// pa_col2 is an array of integers
break;
case 3: rc = SQLBindParameter (hstmt, counter,
SQL_PARAM_INPUT, SQL_C_BIGINT, (SWORD) ptype,
(UDWORD) prec, (SWORD) scale,
pa_col3, sizeof(pa_col3[0]), cbValue3);
// pa_col3 is an array of 64 bit integers
break;
...
default: break;
}
The application in this case study is an executive dashboard, which allows the
company's executive team to have a view into the sales system. The IT team
responsible for deploying the application developed an extensive set of perfor-
mance tests designed to measure response time while the system was under load.
Environment Details
The environment details are as follows:
•
The dashboard is a browser-based application that connects to both systems
inside and outside of the corporate firewall using JDBC.
•
The application accesses data in Microsoft SQL Server and three DB2 data-
bases.
•
Outside the firewall,
the application also accesses data from
•
During the performance testing of the application, the IT department used a
third-party tool to emulate five to ten concurrent users on the system.
•
The application is deployed in an IBM WebSphere environment.
