What's New in VistaDB 5?

VistaDB 5 is Faster and Better than Ever

VistaDB 5 includes significant improvements in performance, SQL-compatibility, security, reliability and tooling.
Key improvements are summarized below and detailed in our documentation and release notes.

Performance

We have done a deep dive into the way VistaDB processes queries and implemented many query optimizations. Relative to VistaDB 4.3, VistaDB 5 is generally 25-30% faster across the board with some queries now running in milliseconds rather than seconds, seconds rather than minutes.

SQL Compatibility

VistaDB 5 includes new T-SQL language features such as ANSI standard OFFSET/FETCH paging as well as new data types including DATETIMEOFFSET, DATETIME2, DATE, TIME, DOUBLE PRECISION, FLOAT, BINARY(N) and VARBINARY(N). VistaDB 5 also includes improved compatibility with T-SQL scripting and improvements to SQL functions such as CONVERT and RAND.

Security

The previous database encryption which used a managed implementation of Blowfish has been replaced with the FIPS-compliant AES implementation built into the .NET runtime. When an encrypted database is upgraded it will be converted from Blowfish to AES. For .NET 4.0 and later the FIPS-compliant unmanaged implementation built into the .NET runtime (which leverages the Microsoft Crypto API underneath) is used. For .NET 2.0 the managed implementation is used since the FIPS-complaint implementation isn't available.

The new encryption support is now database-wide instead of requiring individual columns to enable encryption. This protects the entire database including schema. This mode is also faster than the previous implementation.

Reliability

VistaDB 5 includes dozens of fixes for errors in the query parser and execution engine that have been reported by users of the past couple years. Additional bug fixes correct issues reported in VistaDB tools and Visual Studio integration.

Tooling

VistaDB 5 includes improvements to the Data Migration and Data Builder tools as well as support for Visual Studio 2013 and Entity Framework 6. In addition, VistaDB includes new diagnostic logging support that you can use with Gibraltar Loupe or other logging tools to assist with database debugging and query optimization.

Upgrading

VistaDB 5 offers dramatically improved performance than earlier versions of VistaDB as well as many bug fixes and tooling improvements. VistaDB 5 includes direct support for upgrading VistaDB 3 and VistaDB 4 databases. VistaDB 2 databases can also be upgraded, but require one extra step using a tool we can provide.

Contact us for upgrade pricing from previous versions of VistaDB.