in reply to Sybase::BCP & iowait

A couple of issues:

First, although your are creating a Sybase::BCP object, you are really using methods in Sybase::DBlib (which are inherited by Sybase::BCP).

To start off I'd suggest changing the Sybase::BCP reference to Sybase::DBlib and see if that improves things.

Still, that shouldn't create the problems that you are seeing (or at least I don't think so!)

In any case all of the IO due to the bcp operation should be done by the time bcp_batch and bcp_done return. Is the database server on the same box, or are you going through the network?

Other than the possible swap storm mentioned earlier I don't see what could be causing this problem...

Michael

Replies are listed 'Best First'.
Re: Re: Sybase::BCP & iowait
by Tanalis (Curate) on Nov 12, 2002 at 16:11 UTC
    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

[reply]
      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

[reply]

In Section Seekers of Perl Wisdom