Writing the data to disk in background? It was just an ideia. Did you try to split the SP in different parts? It is difficult to do it? It was just an idea!

Artur

----- Original Message -----
From: guido.klapperich@...
To: ib-support@yahoogroups.com
Sent: Monday, February 25, 2002 11:22 PM
Subject: Re: [ib-support] Disconnecting takes very long


> The first thing that occurs to me it's: I think 20 minutes could be ok because we are talking about one SP that will do 700.000 posts inside the same transaction. When you commit, the server must handle this large amount of data in one single commit.
>

After executing the sp I do a commit, that takes up to 10 seconds, then I thought all is commited. But what is IB doing while disconnecting ?

Guido




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