Guido:

> Writing the data to disk in background?
> But I thought after commiting all data should be written to the disk, or

am I wrong ?

No, you are not wrong. What IB does is tell the Operating System that it
should save the data to the hard disk. The operating system will say 'ok'
and IB will be happy and continue doing it's job. But your problem was
'After executing the sp and commiting the transactions it takes up to 20
minutes to disconnect from the server'. So, I thought that the server was
really doing something that do not allow them do disconnect.

You are using local connection: what is the operating system that you are
using? What I suspect is that the Operating System is doing something on the
background (flushing the data into the hard disk) with a very high priority
that do not allow IB to 'get back to his job' and reply to your application
'ok, disconected'.

> It was just an ideia. Did you try to split the SP in different parts? It

is difficult to do it?

> Yes and another point is, when someting goes wrong I can rollback all

changes at one time.
This was just for isolating the problem. Never mind.

Artur