From 4.523 DP4 will support server side execution of SQL. This should improve performance on complex queries which filter records in a way that is not optimised, as it will cause the filtering to take place on the server rather than the client, thus reducing the network traffic.
To enable this enhancement you must upgrade USRLIBT.DLL on both the server machine and client machines. Load the new component TCPSQLM.W32 in place of TCPMGR.W32 on the server machine. This is a direct replacement for TCPMGR.W32 with support for SQL added.
Install the new SQLLIBT.DLL on both server and client machines. On client machines the SQLLIBT.DLL can behave as an interface program and pass calls made to it across to TCPW.W32. On client machines edit DATAFIT.INI and create the entry remote=1 in the [SQLLIB] section, (create the section if it does not already exist). You must only do this if the machine runs as a pure client, i.e. it loads TCPW.W32 only, and not DP4SRVR.W32 or any ADCs.
Use the replacement TCPW.W32 in place of your current version of TCPW.W32 on the client machine.
This is a proof of concept enhancement. There may be network timeout problems on some SQL operations e.g. deleting an entire table. In the final release TCPSQLM.W32 will probably be multi-threaded to avoid this problem. The download for this enhancement is password protected. Please ask us for the password if you would like to use this enhancement.
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.21 May 2001 Revised to include E4000030. Please post SQLERR.PRN to your system database with the 4.5xx version of MAPPOST.