Formatting SQL - very slow the first time

Toad for SAP Solutions
1

Formatting of this simple sql takes about 3-5 seconds the first time I run format sql.

“SELECT dbo.format_fnr (t.DAT_KUNDE_FOEDT_NUM, t.IDE_KUNDE_PRSNR)
FROM tabell t
WHERE t.dat_kunde_foedt_num > 19421231 AND t.DAT_KUNDE_DOED IS NULL”

The second formatting of this sql, is done in a matter of milliseconds.

Is this normal?

2

Hello Olona,

There is some initialization the first time you use the SQL formatter but it should not be 3-5 seconds. When you have a chance please send the support bundle information so I can test on a similar environment.

Thanks.

3

Hey Micheal,

Just sent you a support bundle, hope it will be of some help.

(Could be that my system is just terrible slow.)