in reply to Re^2: Perl DBI (sybase) rapidly delete large number of records
in thread Perl DBI (sybase) rapidly delete large number of records

There's about a million variations of this problem. It would help if you could submit some code and/or data that demonstrated how it is that you're sending the temporary data to the database and which (may) illuminate possible solutions.

Presently, it feels like there is no solution; but that seems to be false since you have some way to "shell out" to produce the temp table.

UPDATE: No, no, you miss my point entirely. If you can find a way to "shell out" and do what you want, then there's almost certainly a way to do it in perl. I still don't think I know enough about the problem or what you're doing when you "shell out" to be able to provide more information.

-Paul

  • Comment on Re^3: Perl DBI (sybase) rapidly delete large number of records

Replies are listed 'Best First'.
Re^4: Perl DBI (sybase) rapidly delete large number of records
by simm42 (Novice) on May 07, 2007 at 11:59 UTC
    The shell call is to a program called bcp - a sybase utility which copies data from a file (with specified field widths or delimiters) into a table.

    I think you are right though that there is probably no solution in perl, bar possibly the one below of doing the delete in blocks, I suspect the bcp method is going to prove faster though, given it is an optimised utility.... just a shame its closed source - might have been nice to build a module incorporating it...
[reply]

In Section Seekers of Perl Wisdom