Time to create the trigger too long

[Former Member]

OS: WinXP sp3 32bit; SQL Anywhere: 11.0.1.2701

When reload DB, if table have GLOBAL autoincrement primary key, then time to create the trigger too long (depend of table width and count of records). Workaround: defining triggers in another file.

This is normal behavior?

case# 11701261

[VolkerBarth]

Could you please tell more details?

Is the trigger part of the reload.sql file? How do you measure the time it takes for the CREATE TRIGGER statement?

[Former Member]

Is the trigger part of the reload.sql file? yes

How do you measure the time it takes for the CREATE TRIGGER statement?

CREATE VARIABLE aTime timestamp go

set aTime = current timestamp go

create trigger test_trigger1 before update order 1 on dba.test <skip>

print string('create test_trigger1 seconds: ', DATEDIFF(second, aTime, current timestamp)) go

I can't attach file. I need more reputation points 🙂 (>100)