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

> terminating CF will do nothing. If the process is indeed going to

take a

> week to complete (hard to imagine - but still) you can just stop the

server

> using the server manager.
> If you are worried about the data, you will need to backup/restore

the

> database, otherwise I doubt anything will be untoward.
> maybe tell us what te process was doing exactly
> Alan