SQL, and SQLEXE now accept the following command tails.
Restricts programs to readonly operation
Disables private database. With 4.616/617 DP4SRVR.W32 this can reduce the time to execute DELETE FROM TableName by as much as 50%. This command tail requires the new SQLLIBT.DLL to be installed (the other two tails described work with any version of the DP4 SQL Library). However the time for this type of statement to execute can be speeded up much more if you install the new Database manager described in E4000016. In this case the benefit of -noprivate is less significant, but possibly still worth having if you are sure you do not need the private database.
This also disables the private database, and additionally disables all parent checks, child deletes and orphan checking. This may improve performance by a further 20%, (more if child deletes would have been performed) though it should obviously be used with caution as normal constraint checking is disabled.
A "go faster" checkbox has been added to the DP4 ODBC DSN configuration dialog. Selecting this option has the same effect as the -noprivate" command tail described above, (not -gofaster, though if you also specify "Omit checks" you will get almost the same behaviour), and hence requires the new SQLLIBT.DLL to be effective. Suggestions for a more a more suitable caption for the checkbox gratefully accepted! The option is stored as no_private=0 or no_private=1 in the odbc.ini file.
21 September 2000. The version released on 11 September contained a file corruption. SQLLIBT.DLL has been updated to fix a problem with the LIKE operator used via ODBC.
You are highly recommended to also download E4000016 as this version of SQLLIBT.DLL has performance optimisations that only become effective with the new DP4SRVR.W32
Beta software is supplied without warranty and should not be used in live sites without the agreement of Itim Technology Solutions. Compatibility with an eventual final release cannot be guaranteed.The sql.m5, and sql.m6 contained updated help maps for SQL.EXE, which you can use to update your system dabtase if you wish. It is not necessary to do so however.