> Right now I'm a bit concerned about the scenario where the fetching
> operation got interrupted... which means the process will stop mid-way
> before all records got processed... any thoughts? Should i go ahead with
> this approach?
>
> Thanks in advance.
> sugi.

your processing is done under transaction control - if it's interrupted, the
transaction will not be committed so you'll have to do the processing again
anyway.

>
>
> PS:
>
> Just in case anyone's interested, I'm testing the second approach on a
> smaller dataset on my development machine: AthlonXP2500,Firebird 1.5.2
> Win32, 512MB RAM, Fresh database.
>
> 1292 records processed in the FOR SELECT.
> 1292 records inserted into the MASTER table.
> 6323 records inserted into the DETAIL table.
> Tested three times, elapsed time between 19 to 23 seconds.
>

this seems a bit slow to me - I'd be determined to get it faster
Alan