Performance Improvements
Performance Testing is now a part of the Ingres Release Cycle.
A Performance Test Harness has been designed to run multiple benchmark tests to establish performance comparisons for each new release and the prior release of Ingres. These tests include, but are not limited to, TPC-H, TPC-DS and TPC-C workloads.
The Performance Test harness is run against heap (transactional) table type before release and any significant performance degradations are addressed before release.
Ingres 12.0 testing showed no performance degradations over the previous release, in fact it showed a small improvement in performance.
GCC Het-Net processing:
The performance enhancments for GCC Het-Net Processing include:
• Simplified single-byte charset processing by separating from double-byte and multi-byte processing.
• Negotiate transport format for integers and floats to utilize server format where possible.
• Charset transliteration is now performed on the client in most cases.
• Optimized varchar padding compression for query parameters on client to eliminate need for heterogenous data processing on server.
• Enable varchar padding compression for repeat queries as is done for regular queries.
• Eliminate heterogeneous data processing on server when the processing can be done entirely on the client and the negotiated transport formats and charset match the server instance.
GCC & GCD Stacks: The Net Server functionality has been incorporated into the Data Access Server (DAS). DAS can now handle both Ingres/Net and thin client (JDBC/.Net) connections, either on a single port or can be configured to support multiple ports including standard Net and DAS ports.
Last modified date: 08/29/2024