It is difficult to provide any hard number because the response time varies so much depending on the environment. There are a number factors that can affect response time:
* Network traffic
* Host CPU model and its current user load: lack of system resources like memory, disk space, and CPU power. Too many users trying to update or read the same records at the same time can cause locking problems.
* Condition of communications line
* Macintosh model
* Database brand
* Database design: Bad design can make finding or updating certain records take a long time.
* Operating system set up
* Programs
Additionally, a DAL query, though simple, can result in one or many records to be selected. Depending on the machine's host load, a 2400-baud connection will work. For DECnet tunneling, we recommend a line speed of 56K or faster to achieve reliability and good performance.
Article Change History:
07 Nov 1994 - Reviewed for technical accuracy.
Support Information Services