Subject | Commit in Stored Procedure |
---|---|
Author | Bayu |
Post date | 2003-01-28T02:36:28Z |
Hi all,
My production system is about processing update about 300.000 records every
night.
And this processing is in stored procedure
If i execute the sp on this records it takes a long time ... and then
commited
But when execute with divide this record and processing about 50.000 records
in each execute sp, this takes a short time.
How can i set the sp which every 5.000 will commit this update with IBO ?
Sorry for my english
regards
My production system is about processing update about 300.000 records every
night.
And this processing is in stored procedure
If i execute the sp on this records it takes a long time ... and then
commited
But when execute with divide this record and processing about 50.000 records
in each execute sp, this takes a short time.
How can i set the sp which every 5.000 will commit this update with IBO ?
Sorry for my english
regards