The “SET SQLCOMPILE” Command Zim is designed to take advantage of many characteristics of a given SQL server. Many SQL servers provide compile time facilities to increase performance at runtime. A compile time option enables you to control when the database server does certain compilation functions such as statement parsing. If SQLCOMPILE is OFF, then…
Read more
A dynamic configuration setting called “block factor” can be used to tune performance. This factor is the number of records retrieved by Zim each time it fetches records from the database. The larger the number, the fewer times Zim has to query the database, and the more time it takes to retrieve a block. So,…
Read more
Zim is capable of executing database commands in either of these three modes: SQLMODE SQL mode SERVERMODE Zim Integrated Server mode ZIMMODE Standard Zim mode The default mode of operation is SERVERMODE. For all database servers except Zim Integrated Server, SERVERMODE and SQLMODE behave identically. In SERVERMODE, a Zim client accessing tables on Zim Integrated…
Read more
In order to access relational databases, Zim client-server generates SQL statements. You can see the statements generated by setting SQLTRACE on. Statements are generated when Zim statements containing references to SQL tables are parsed, compiled, or executed interpretively. Previewing the SQL statements generated provides an insight into the type or amount of work the database…
Read more
The application is compiled using the “compilemode” option “sqlmode” and conversion to a Zim Client-Server application is complete. If the application is to be developed for execution against a pre-existing SQL server database, then the Zim application should be compiled using the “compilemode” option “zimmode” to test the application for functionality and performance. Then the…
Read more
Zim 9 always runs under a Client/Server architecture where Zim Server is the server and the clients can be Zim, Zim Thin Client (ZIMTC) or ZimExplore. Zim Server can manage any number of different Zim databases at the same time, all of them located in the same physical machine where Zim Server is running (a…
Read more
Zim Server has many possible configurations. multi-user single-user Zim Integrated Server Usually, the Database Agent process accesses a local Zim database (local refers to relationship to the server). The Database Agent process is started much like any version of Zim: it has its own working directory; it uses Zim directory files to look up…
Read more
Zim enables you to connect to more than one remote database at the same time. This enables you to do join operations between different databases on different machines managed by different Zim database servers. No support for distributed concurrency control is available; updates which span multiple servers, though permitted, should be performed with care. As…
Read more
It is very important to make a distinction between Zim 9 Server and Zim Server Connectivity. Zim 9 Server always operates in Client/Server mode where Zim Server is the server and Zim, Zim Thin Client are the clients. The clients run a Zim application that accesses data provided by the server. Every time a client…
Read more
English 
Portuguese