Put a counter in and commit after every 2500. Make sure you do a final
commit
outside your loop.

i := i + 1;
If i > 2500 then
commit;
i := 0;
end if;
end loop;

commit;


mp527 wrote:

>
> It's a dual pentium 4 xeon on Linux :-)
>
> Yes,
> I am doing a commit per record.
> each record is imported by a stored proc that does some aditional
> lookups and comparisons.
>
> I will adjust my commits and see if that improves it.
>
> Thanks,
>
> Tony
> > I'd recommend you to upgrade your Commodore 64, or at least buy
> yourself a
> > disk drive to replace the tape!
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com




[Non-text portions of this message have been removed]