TurboDB 5 comes with a large number of new and enhanced features. Note that some of those new features require existing tables to be updated to table level 4 in order to be available. Check in the respective section to learn whether this is the case.
| • | The top keyword restricts the number of rows in the result set |
| • | Time fields with a resolution of seconds or milliseconds |
| • | Transaction support with automatic crash recovery |
| • | Better typed aggregated columns |
| • | Join conditions can now be arbitrary search-conditions including calculations and logical operands, not just comparisons |
| • | Nullable character types |
| • | Managed databases with database-wide properties |
| • | Optimized page sizes according to predefined capacity (table level 4) |
| • | Supports up to 50 indexes per table (table level 4) |
| • | The index files are named <table name>|<index name>.ind to prevent naming conflicts (table level 4 only). |
| • | Supports column names with spaces and special characters (table level 4) |