Focal Point
[SOLVED]Bad performance running a VBScript from within WebFOCUS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6827034506

June 14, 2011, 06:55 AM
Håkan
[SOLVED]Bad performance running a VBScript from within WebFOCUS
We've got a VBScript which retrieves information from Active Directory. The script works fine, but the problem is that while it takes some 30 - 45 seconds to run from the command prompt, it takes well over 1 hour! when running from WF.

It's not consuming

I've tried with a number of different ideas:
!script.vbs
CMD script.vbs
!batfile.cmd which invokes the vbs script
CMD cscript.exe script.vbs (the current version)

Has anybody have any idea what's going on?

We're on WF 7.6.10 on Win XP/2003.

Tia
Håkan

This message has been edited. Last edited by: Håkan,


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
June 14, 2011, 05:42 PM
Waz
I wonder if it is because of the agent getting small amounts of CPU.

Have you tried the SYSTEM function ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

June 14, 2011, 06:00 PM
Håkan
Waz

sorry, forgot mentioning that. Yes, I've tried that too.

Regards
Håkan


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
June 15, 2011, 12:46 PM
Håkan
I never managed to find a solution to the problem using VBScript. Instead I diverted to Python, which created the text fle in 1 second from within WebFOCUS. I'm still not sure what VBScript is doing behind the scenes, but I don't care anymore.

Håkan


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)