Sybase Enhances Performance with Advantage Database Server
The company improves performance and adds Visual FoxPro 9 support to its Advantage Database Server offering to gain an edge in the market.Sybase is looking to bolster both performance and productivity for users with the release of the latest version of Advantage Database Server. Version 9.0 of the product, announced March 17, is one of two embedded database offerings from Sybase. It includes a number of enhancements aimed squarely at application developers. For starters, the company has built in what officials say is a more efficient way to optimize multi-segmented filters by evaluating the most restricted segment first.
"When the evaluation of the more restrictive segments results in only a few rows passing the filter, the server will short-circuit the index scan of the less restrictive segments, [to avoid] the cost of scanning many index pages," said Chuck Vertrees, product manager for Advantage Database Server at Sybase iAnywhere. "This optimization is most useful when the filter is applied to a very large table [more than 1 million] and when one or more conditions are significantly more restrictive than the others."