Subject RE: [IBO] Commit in Stored Procedure
Author Alan McDonald
Jason - I think he's doing all the processing on the server - there's no
records coming back to the client.

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Wednesday, 29 January 2003 8:43 AM
Subject: Re: [IBO] Commit in Stored Procedure

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

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to