Kbase P25627: Why SQL-92 engine is better in version 9.1D?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/28/2003 |
|
Status: Verified
GOAL:
Why SQL-92 engine is better in version 9.1D?
GOAL:
The SQL-92 engine enhancement in 9.1D
GOAL:
Why SQL-92 engine performance is better in version 9.1D?
FIX:
A new enhancements of 9.1D is the performance gains for the SQL-92 Engine.
The new Progress SQL-92 engine is a high-performance SQL processor that is consistent with the requirements of the current SQL standard (ANSI SQL-92 Entry-Level) for application development. Some features of the Intermediate level of SQL-92 are also included.
The SQL Engine includes a state-of-the art cost-based query optimizer that analyzes all queries and creates a query execution plan, taking into account access paths, data distribution statistics, and algorithms to provide high performance execution for complex queries.
SQL-92 Sequences and SQL-92 threading have also been introduced in Version 9.1D.
The current standard in effect for the SQL language is ANSI SQL-92. Progress Version 9 is compliant with the requirements for SQL-92 Entry Level+. Enhancements have been made to improve SQL-92 performance and increase scalability. Enhancements include an improved query optimizer and extended functionality for the JDBC driver.
One benefit of these enhancements is that SQL-92 OLAP deployments are now more robust and flexible.
Another is that the SQL-92 engine now has improved support for business intelligence and other third-party tools.
In Progress Version 9.1D, SQL-92 sequences have been introduced. These are used to generate sequence numbers for table rows, and to generate unique primary keys for these rows.
Also in Version 9.1D, Progress developers can take advantage of true SQL-92 threading with their
applications. New broker startup parameters distribute 4GL and SQL-92 client work requests:
· Minimum Clients per SQL-92 Server
· Maximum Clients per SQL-92 Server
· Type of Server to start (4GL, SQL or both · which is the default)
In addition to the broker parameters, new SQL-92 Server startup parameters have been introduced to allow
for greater flexibility:
· Stack Size · default of 1Mb
· Statement Cache Size · default of 100 statements
Finally, the scope of shared locks in the SQL-92 locking protocol has been narrowed in Version 9.1D from the connection level to the transaction level. This allows for multiple physical connections to the database from the connection pool.