Hi experts,

I am working in Baan IV

I need to know if exist some way to compile a program script and show me in a log the time that it has taken each sql instruction.

I listened about compile with debug profile the program script.

Anybody can explain me how to do it?

The question is for I have a big problem, because I am making a select instruction to one table that it has a lot information (tfacr200), and then this instruction, take a lot of time.

What should I do in this situation?

Thank you a lot

You may want to do a search for posts on tracing.

Thanks,

Vince

Hi,

To know about execution times, one of the way is to compile the script in Profiling mode. In baan 4, if i remember well, its in the second form of the maintain program scripts session.

Hi experts,

I am working in Baan IV

I need to know if exist some way to compile a program script and show me in a log the time that it has taken each sql instruction.

I listened about compile with debug profile the program script.

Anybody can explain me how to do it?

The question is for I have a big problem, because I am making a select instruction to one table that it has a lot information (tfacr200), and then this instruction, take a lot of time.

What should I do in this situation?

Thank you a lot

Hello, start BAAN with / like :

-- -keeplog -logfile mysqllog -set TT_SQL_TRACE=02000

Regards

Hi,
I tried
compile the script in Profiling mode
but when I execute the sessions or 3GL scripts I cannot see any report or something similar by which I can know the execution time. I tried it in Baan IVc4 as well in Baan LN

As well, I have even tried
-- -keeplog -logfile mysqllog -set TT_SQL_TRACE=02000
But the file created mysqllog in the tmp folder has nothing except TT_SQL_TRACE=02000.

Please help me, where I am going wrong.

Thanks in advance.
--Rahul

Pleas try:

-- -set PROFILE_ALL=1 -set PROF_DIR=/home/bsp

* PROFILE_ALL. Setting this parameter to 1 starts profiling for all objects.
* PROF_DIR. Redirects the output file to the specified directory. Else it will be placed in BSE_TMP.
* PROF_RTIME. When set to 1 to get also a section sorted on wall clock time (real time) will be added.

-- -set PROFILE_ALL=1 -set PROF_DIR=<path for file> <session name>

example:

-- -set PROFILE_ALL=1 -set PROF_DIR=/appl/baan5/bse/home/bsp tfgld1101m000

Regards,

Kozure

Hi,
I tried

but when I execute the sessions or 3GL scripts I cannot see any report or something similar by which I can know the execution time. I tried it in Baan IVc4 as well in Baan LN
--Rahul

When you compile any script in profiling mode and then execute the session/script, a html file is created in your home directory or tmp folder, this html file contains all execution times...Not sure if this file is created in tmp or $HOME :confused:, plz check both the folders after executing the session ...

Hi,
Thanks a lot Kozure and Cyprus.

-- -set PROFILE_ALL=1 -set PROF_DIR=/home/bsp

This worked for me and I can view the html file in the mentioned directory (PROF_DIR).

As suggested by Cyprus. If I dont give path for PROF_DIR. The html file was created for me in tmp folder.

I even got the information that the name of the file is in the format
profile.<pid>.<session name>.<bshell_pid>.html

Thanks again,
--Rahul