Response Time on Netware Environment

[Vickram Nathan]

Could you tell me what would be the maximum number of
terminals that can work with the least possible amount of
response time in an environment where VB is the front end
& MS Access is the back end.

The application will be used mainly for quering and
occasional updates. So the response time is critical.

Could you give me a idea of the cut-off point where the
response time will not be that effective?

This is running on the latest Netware server.

Regards,
Vickram Nathan

 

[Larry Linson]

Could you give me a idea of the
cut-off point where the response
time will not be that effective?

There are too many factors, most of them specific to your environment, for
anyone to make a prediction about a particular case.

Factors in how many users can be supported in multiuser include the
requirements, design, and implementation of the database application and the
hardware, software, and network environments. If all factors are near
perfect, we have reliable reports of over 100 concurrent users. Even if not
all are near perfect, we routinely see reports of 30 - 70 users. But, in
cases where we are rather sure that all are about as far from perfect as can
be, people have reported Access "falling over" with as few as four users.

I'd venture to guess that if someone went out of their way to do everything
wrong, it would be possible to create a database that wouldn't even support
one or two users. <GRIN>

Larry Linson
Microsoft Access MVP