Integrated Database

The storage and processing capabilities of 4D v11 SQL take a giant step forward without compromising performance. The previous limits are expanded, meaning that existing databases immediately enjoy more breathing room.

Your 4D v11 SQL projects are now up to the challenge of even the most demanding projects.

Volume

Expanded capacity lets you address your ever increasing data storage requirements.

Performance

New mechanisms mean guaranteed performance regardless of data size to process.

64-bit file access
Optimized memory management that is 64-bit ready
Read-ahead buffers generalized for access to data file
Optimized management of sizeable fields, such as pictures, blobs, etc.
Native ultra-quick access to Unicode characters through removal of internal conversions with ASCII.

4D v11 SQL also provides new kinds of specialized indexes that optimize requests:
Composite Index: simultaneous indexing of values from two or more fields (for example, First Name and Last Name).
Keyword Index: Indexing every word of text for near-instantaneous whole-body text searches.

Cluster Index: This is particularly interesting for fields with redundant values.

Transactions

4D v11 SQL provides a multi-level transaction management system loaded with automatic sub transactions.

Architecture Universal Binary

4D v11 SQL’s architecture is 100% Universal Binary. This modern architecture lets you take full advantage of the power Intel processes in Apple computers.

Auto-administration

A 4D v11 SQL database in production requires no real maintenance due to built-in mechanisms that guarantee that your database will work. These mechanisms are easily configurable using a set of tools that are easily accessible from a unique interface (the Maintenance and Security Center) or using the 4D programming language.

Back to the features list

Explorer >>

When the solution matters

International Sites

Product Lines

Solutions

Corporate

Support

Purchase