|
|
|
SQL Optimizer Improvements
Continuous efforts have been made to improve optimizer strategies for execution plan construction. An overall enhanced engine brings numerous new features and performance to your existing No+SQL applications.
Tables Open Faster
Table Open/Close logic has been optimized eliminating a number of unnecessary work by the server This results in far less network traffic when opening tables, which yields a dramatic performance improvement over higher latency networks.
Tables Unlock Faster
Table unlock logic has been optimized improving overall SQL performance.
Indexes Update Quicker
A new compile-time option causes certain cleanup operations to be skipped on an index update resulting in a substantial performance improvement during this operation.
Large Number of Values in an IN List
The logic used when processing a query containing a very large number of constant entries in an IN operator has been thoroughly analyzed and changes have been made to improve processing. New logic speeds up execution when the number of entries for the IN operator is large (>1000).
Reduced Table Scans
New logic avoids unnecessary table scans when scan condition are known to be false based on possible field values.
Table Locks
Table Locks prevent other connections from reading and/or writing to the file. These can greatly reduce resource usage and contention with other connected users.
