in reply to Re: Sybase::BCP & iowait
in thread Sybase::BCP & iowait

Michael,

I've changed the BCP reference to DBlib; though this has had little effect on the problem.

The db server is not local - it's accessed via the network.

Is it possible that the DB is getting swamped and it's this that I'm waiting for, do you think?

Thanks for the help.
-- Foxcub

Replies are listed 'Best First'.
Re: Re: Re: Sybase::BCP & iowait
by mpeppler (Vicar) on Nov 12, 2002 at 16:31 UTC
    Is it possible that the DB is getting swamped and it's this that I'm waiting for, do you think?
    No, I don't think so. bcp_batch() shouldn't return until all the data has been transfered to the server, and the server has acknowledged that it has committed all the rows.

    I think the problem is elsewhere...

    Michael