The flexibility of smart client is tied into the way the application is constructed. It is an application that has been developed in two separate parts. This requires more development work and hence is more expensive, but it’s an investment that pays off. The first part is the application that sits on the workstation (written in .Net, the world’s most advanced programming language) and it’s this application that contains the bulk of the programming work. The other application is for the database, which sits on a server (written in Microsoft SQL 2005, the world’s latest, most advanced and feature-rich database programming language, and probably the world’s easiest to maintain). The two applications work together, but also independently.
The architecture of smart-client allows a basic workstation to operate as fast as any normal computer-installed application (like Word, or Excel). There’s no waiting, and no lag. However, the master database of all the files and information is kept on the SQL database server, so the workstation talks to the server when it needs information.