Subject Re: [IBO] Commit in Stored Procedure
Author Jason Wharton
Make it a select procedure and have it return a "fetch" every 50,000 records
and then the client can simply do a commit-retaining for each fetch that
comes back.

Jason Wharton
CPS - Mesa AZ

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Bayu" <bayu@...>
To: "IBObjects" <>
Sent: Monday, January 27, 2003 7:36 PM
Subject: [IBO] Commit in Stored Procedure

> Hi all,
> My production system is about processing update about 300.000 records
> 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
> 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