Re: VBA-Script consumes 100% CPU on Server

I bet the VB script is not using host variables. I suspect that you are forcing frequent reparses(probably on each and every query); this would produce a high CPU usage on a server.

If you use host variables (e.g. Oracle OLE objects and use parameters intelligently) then you should notice a dramatic reduction in CPU usage and a performance improvement. If you post a section of the query code you are doing that might tell us something.
Jim
"Peach" <schoedema_at_my-deja.com> wrote in message news:8t4ojr$mel$1_at_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 - 19:55:57 CDT