Hello All,
I have written a 3gl script which reads information from audit files and generates a report.
But the problem is this script takes lot of time to complete the process.
If I use baan sessions (e.g. ttaad4463m000) to print audit files then it takes less time compared to my custom 3gl script.
Could someone please suggest me a way to improve 3gl script so that it becomes time efficient.
I am also attaching my script for your reference. Please check and let me know if I am missing out on something.

Hi,

Code looks fine. May be you can try using CSV instead of XLS also you can try using Baan Report instead of writing it to a file in case if that is not a special requirement.

Again, can't say that will make any difference.

Hi,

Code looks fine. May be you can try using CSV instead of XLS also you can try using Baan Report instead of writing it to a file in case if that is not a special requirement.

Again, can't say that will make any difference.
Hello bhushanchanda,

Thanks for your quick reply.
I tried making CSV instead of XLS but it didn't help.
Also requirement is to print audit details in custom report so Baan Report won't do.

Thanks & Regards,
SwapnilJ

Hi,

One more thing you can try is, rather than using sequence as 999, try calculating the number of sequences generated for that table.

That can reduce some time as well.

Hi Bhushan,

Yes, I tried that also. There are 40 sequence file for tiitm001 table (whih I am using in script for testing). So, I replaced 999 with 40 but that too didn't worked.

Regards,
SwapnilJ