AcuODBC User's Guide
Version 6.0

2.4 Remote SQL Processing

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 can mean more efficient use of your system resources. Queries often process large amounts of data to get results. Remote processing decreases the amount of data that must be transferred between the client and the server. If files reside on the same server where processing occurs, network traffic is reduced. Only the final result of the processing is returned to the client machine. In addition, this structure encourages centralized management of your data, cutting down on duplication and ensuring that the information returned to the application is up-to-date.

For remote processing on a Windows server, acuodbcs resides as a 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 acuodbcs 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:

Acucorp, Inc.
Voice: (800) 262-6585 (U.S.A. and Canada)
Voice: (858) 689-4500
Fax: (858) 689-4550

Please share your comments on this manual
or on any Acucorp documentation with the
Acucorp Communications Department.
1988-2003 Acucorp, Inc.
All rights reserved.