Subject Performance Large Query / Procedure
Author todderamaa
We have a client with about 10 users. Whenever one of the clients
runs a complex query (a few joins and many records) the other clients
all complain that the system virtually stops responding. They are
running Windows NT.

The same thing happens when they run some procedures that take a
couple of hours to run. I have looked at the 'performance' of the
procedures in Quickdesk and it shows that it is using all the
appropriate indexes.

Is this an Interbase problem, a design problem or a Windows problem?