|
[ Part 11 ]
| |
Middleware in Action: Industrial Strength Data Access
Another Technology Report from Ken North Computing LLC
Data Access Middleware Checklist
<< Previous 1 2
3 4 5 6
7 8 9 10
11 12 13 Next>>
Performance, Scalability
| |
Required (Y/N) |
Connect for ODBC |
Connect for JDBC |
Connect for ADO.NET |
Other driver, provider |
| Asynchronous query execution |
|
n |
n |
n |
|
| Connection pooling 1 |
|
º |
n |
n |
|
| Multi-threaded, thread per connection |
|
n |
n |
n |
|
| Emit TDS packets (Sybase, Microsoft) |
|
n |
n |
n |
|
| Wire protocol, TNS support for Oracle |
|
n |
n |
n |
|
| Wire protocol, DRDA support for DB2 |
|
n |
n |
n |
|
| Adjustable network packet size |
|
n |
n |
n |
|
| Statement caching |
|
n |
n |
|
|
| Performance tuning w/ connection strings |
|
n |
n |
n |
|
| Prepared queries, parameter queries |
|
n |
n |
n |
|
| Use stored procedures |
|
n |
n |
n |
|
| Pre-fetch rows |
|
n |
n |
n |
|
| Use static SQL |
|
n |
n |
n |
|
| Use stored procedures for prepared queries |
|
n |
n |
n |
|
| Create, modify, use DB2 bind packages |
|
n |
n |
n |
|
| Batch inserts and updates |
|
n |
n |
n |
|
| High-availability clusters, load balancing |
|
n |
n |
n |
|
| Redundancy, connection failover |
|
n |
n |
n |
|
| Access REF CURSOR data |
|
n |
n |
n |
|
| Nested Savepoints |
|
|
|
n |
|
| Snapshot isolation level |
|
n |
n |
n |
|
| Efficient memory allocation/object use |
|
n |
n |
n |
|
1 Supported on Windows platforms. For UNIX and Linux, SQL Relay or other third-party software is required.
Copyright © 2007, Ken North Computing, LLC. All rights reserved.
<< Previous 1
2 3 4 5
6 7 8 9
10 11 12
13 Next>>
| |
|
