> Thanks Alan for responding.
>
> I'm starting to think that stopping the Coldfusion server is what I
> need to do. The CF routine is a loop which is set to run 50000 times.
> Each loop includes 4 or 5 separate selects and 3 or 4 separate
> updates on 3 different databases. The databases being queried and
> updated range from .7GB to 2.4 GB in size. Each of the select and
> update queries is treated as a separate CFQUERY. So its like I'm
> doing many individual SQL transactions in each loop iteration. The
> time consuming process (the looping 50K times) happens in the
> coldfusion code not in the SQL queries. The individual SQL queries
> likely don't take too long to complete (its just that there are so
> many of them - one after the other).
>
> So I'm thinking that If I stop the ColdFusion server then it won't
> continue sending out these shorter SQL queries and updates. Does that
> sound right or is there something I'm missing? As I said previously,
> I'm kind of new with Firebird (but I'm very impressed with it thus
> far).
>
> Thanks,
> dbambo2000

yes - if it's CF code which is looping, then killing this process will be a
safe way to kill the whole thing since the transaction it is running in will
not be committed and teh effect of the process will be nil.
It may still be a good idea to backup/restore the db after you kill the CF
process.
Alan
(this whole thing is not a good way to do what you are doing - best ask us
some more questions about what you are doing)