Jason - I think he's doing all the processing on the server - there's no
records coming back to the client.
Alan

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Wednesday, 29 January 2003 8:43 AM
To: IBObjects@yahoogroups.com
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
http://www.ibobjects.com

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

----- Original Message -----
From: "Bayu" <bayu@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
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
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



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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/