PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: Outside of perl when I am doing large deletes I set rowcount to 5000. Then use
Date: Dec 2 1997 1:13AM

Jack Torrey wrote:
> 
> Outside of perl when I am doing large deletes I set rowcount to 5000.  Then use
> several loops of the delete statement until no more rows are returned.  I have not
> used this is in a perl script, it only lessens the chance of locking up.

Yes - this is a technique that works fine.

Michael
-- 
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler