Optimize for Large Numbers of Users

To support the maximum number of users, you may need to increase the temporary dbspace, adjust the operating system parameters, and change the startup parameters.

Relative Priorities of New and Existing Connections

If Sybase IQ is very busy handling already connected users, it may be slow to respond to new connection requests. In extreme cases (such as test scripts that fire off hundreds of connections in a loop while the server is busy with inserts) new connections may time out their connection request. In this situation, the server may appear to be down when it is merely very busy. A user getting this behavior should try to connect again and should consider increasing connection time out parameters.