4D V11 SQL
In 4D 2004, a formula is calculated for each record sequentially. 4D v11 SQL analyzes formulas beforehand to optimize queries. The syntactic analyzer can identify parts of the formula that can be optimized to reduce the sequential parts of the query.
Since the recent announcements about scalability in 4D v11 SQL Release 3, especially in regards to those helped by improved management of multi-processor operations, many people have had questions about the number of simultaneous clients that can connect to 4D Server.
The resource explorer allows you to manage from any node - client or server - resources whose implementation previously required the application be stopped. Whether they're files from your image library or, for example, XLIFF files for localization, you can simply manage all of your resources by dragging and dropping them on the resource explorer.
Instantly view all indexes for maximum productivity
This explorer lets you see all your database indexes in one display. This is a useful maintenance tool that will help you increase your database performances and get the best from 4D.
Design and model the architecture of your database with ease using the 4D Structure Editor.
Just one click
With just one mouse click and the Properties inspector, you can add tables, fields, relations, and change settings on the fly.
4D provides a true enterprise-class database, with the capacity to process massive databases while keeping the same responsiveness and performance you've come to expect in 4D. We've shattered all previous database size limits to give both new and existing databases much more breathing room.
It is up to the challenge of even the most demanding projects.
Our expanded capacity lets you serve ever-increasing data storage requirements without a problem.
Take advantage of the SQL engine
The native SQL engine in 4D allows developers to implement industry-standard SQL within their 4D applications. Learning the 4D language is no longer a requirement to building an application with 4D.
Manage all of your databases
4D natively supports all SQL 92 standards. This allows you to work with both database records (DDL) as well as the structure (DML).