With the AcuODBC Server (acuodbcs), you can perform SQL processing on a remote machine (either a UNIX or Windows NT/2000 server). This is known as two-tier architecture. For optimum performance, the files should reside on the same server where the SQL processing is taking place.
Remote processing facilitates more efficient use of your system resources. Queries often process much data to get results. Remote processing decreases the amount of data that must be transferred between the client and the server. If files reside and processing occurs on the same server, network traffic is reduced. The final result of the processing is all that is returned to the client machine. In addition, this scenario facilitates centralized management of your data, cutting down on duplication and ensuring that information returned to the application is always up-to-date.
For remote processing on a Windows server, AcuODBC resides as an NT service on the remote machine, waiting for calls for SQL processing. On UNIX machines, acuodbcs resides as a daemon. AcuODBC Server is a single-instance server: each time AcuODBC Server gets a request, it spawns a new copy to deal with the request and the original goes back to listening for additional requests. You may run acuodbcs continuously, or start and stop it.
The following illustration depicts the architecture for remote SQL processing:
More: