dblxAdmin - 2013-01-15

Today we are officially releasing v.1.6 of the DBLX database.

This release of DBLX includes the following changes:

  • Change in how selects are performed internally, resulting in large increase in performance for complex queries and/or large tables.
  • Change in how the LIKE clause is evaluated to improve performance.
  • Support for sub-selects. You can now use this syntax:
    SELECT * FROM table WHERE Column IN (SELECT * FROM ... )
    Sub-selects can be nested in any logical order. The column Column must be in the result set of the child subselect.
    Sub-selects cannot be used with IN SET MATCHING. The following IS NOT VALID in DBLX in v.1.6:
    SELECT * FROM table WHERE Column IN (14,34,53,21)
  • changed date code and data format for performance improvements.
  • improved and reduced sql query 'cleaner' code

The next release of DBLX 2.0 will be sometime in April.
Check around the Discussion area for the latest info on the DBLX Database.