warning: file_get_contents( [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /var/www/ : eval()'d code on line 4.

4D Unlimited Desktop

4D Unlimited Desktop lets you deploy stand-alone single user compiled or interpreted 4D applications on an unlimited number of machines.

4D Unlimited Desktop allows you to deploy compiled versions of your 4D applications to users. Your users will not need a copy of 4D on their computer to run these applications. Deployment licenses for office productivity applications 4D Write and 4D View are also included in 4D Unlimited Desktop.


Included in 4D Unlimited Desktop

• SQL database engine

• Supports both compiled and interpreted applications

4D Interpreted Desktop

4D Interpreted Desktop lets you deploy stand-alone, single user interpreted 4D applications on an unlimited number of machines.

“Interpreted” is similar to “compiled” in that 4D software is embedded in your application, so your users won’t need a copy of 4D on their computer to run the application. But unlike compiled applications, the source code is not protected from view. If you want to distribute compiled applications, you will need to upgrade to 4D Developer Professional.


Included in 4D Interpreted Desktop

• SQL database engine

• Interpreted application support

Index Explorer

View every index in your application at a glance.

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.


Index List


4D v11 SQL Self Training

Wed, 2009-09-30 (All day)

Self-training manual and example databases to get you started developing with 4D v11 SQL. (144 mb)

4D v11 SQL in a Real Application

4D v11 SQL performance tests under real-world conditions.


Is the whole greater than the sum of its parts?


This is the question we had in mind when creating some of the new algorithms in 4D v11 SQL. Although every command has received individual attention, and while we know how to assess their improvements through unit tests, it’s the perception of the user that determines the total improvement in performance.


Query by Formula - Standalone

Speed improvements in Query By Formula under 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.


Query by Formula - Client/Server

The speed of Query By Formula execution on the server side under 4D v11 SQL.


In 4D 2004, a Query by Formula is executed on the client end. This means that every record must pass over the network to have a formula applied, and to determine if it will be part of the selection. When the logic of the request allows it, 4D v11 SQL will perform queries directly on the server to avoid extraneous loads on the network. Only the selection is returned to the client end, as with a classic query.


Let’s go back to the formula for measuring distance used in the test QUERY BY FORMULA (standalone).


List Box: Current Selection

Fri, 2008-12-19 (All day)

A video tutorial on how to use a List Box based on Current Selection.

4D Server v11 SQL Scalability test

How many simultaneous, active clients can 4D Server handle? This laboratory scalability test examines the limits of a real application on 4D Server v11 SQL.


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.