Infobright Blog

The Infobright Optimizer Extends Its Reach!

Today we’re very excited about the new release of ICE 3.2 (release candidate 1), which builds on the expanded depth of query functionality introduced in version 3.1, where we delivered over 120 additional SQL functions fully optimized in Infobright’s high performance Knowledge Grid.

Infobright 3.1, released in March, delivered up to a 10X performance boost for complex queries using our new optimized SQL functions. Version 3.2 further advances the breadth of query support where customers will experience further increases in performance. Extending the query coverage in the Knowledge Grid means more queries run natively thru the Infobright Optimizer without any query restructuring–resulting in effortless performance.

Infobright beta users have seen significant performance increases with our 3.2 release for queries now going through the Infobright Optimizer. For example, queries that previously ran in hours are now taking seconds, and queries that previously ran in 20 minutes are being returned in less than a second. This reflects the huge benefit achieved by Infobright’s query optimizer using rough set algorithms.

Infobright 3.2 expands the support for SQL functions allowing complex expressions to execute within the Infobright Optimizer. Support for complex expressions have been implemented on the SELECT list with GROUP BY, and the ORDER BY, UNION, HAVING, WHERE, DISTINCT, LIMIT, IN, and OFFSET clauses, and across a broader range of sub-queries.

Infobright 3.2 includes support for Windows Server 2003/2008. New install packages have been introduced to improve the user experience, facilitate ease-of-install and configuration. The install packages automatically detect upgrade versus new installs, updating the software seamlessly while preserving data and configuration settings.

The Release Candidates for ICE 3.2 are available immediately and IEE 3.2 release candidates will be available in the next 2 weeks!