| Subject | Firebird with Trigger when select procedure got problems |
|---|---|
| Author | jeremylim2008 |
| Post date | 2007-01-04T03:15:17Z |
I got a standard system with 3, 000 customer(s) using it. But some
customers with big transaction when they doing a complicate
store procedure select statement it will running endless cannot
finish and will hang there but when I use Task manager checking it is
still running with near to 100% Usage.
But when I off all trigger(s) the store procedure will complete
running.
But this only occur for 2 to 3 database out of 3, 000 databases.
How can I trouble shoot this.
customers with big transaction when they doing a complicate
store procedure select statement it will running endless cannot
finish and will hang there but when I use Task manager checking it is
still running with near to 100% Usage.
But when I off all trigger(s) the store procedure will complete
running.
But this only occur for 2 to 3 database out of 3, 000 databases.
How can I trouble shoot this.