VBA-Script consumes 100% CPU on Server

From: Peach <schoedema_at_my-deja.com>
Date: Tue, 24 Oct 2000 19:40:45 GMT
Message-ID: <8t4ojr$mel$1@nnrp1.deja.com>

Hi all

There is a VBA-Script on a client doing a lot of queries and calculations against an Oracle 8.1.5 instance, which resides on a Windows NT 4.0 Server. This VBA-Script is running for about 3 hours and consumes 100% CPU time. There is no swapping on the server and enough SGA.
Other applications are running very slow, of course.

How can I define, that this VBA-Script should not using all the cpu time? It is ok if the VBA-script is running slower.

Peach

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 24 2000 - 14:40:45 CDT