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: vipulp at fir dot ml dot com (Vipul Parikh)
Subject: Re: BCP module speed
Date: Feb 21 1996 2:37PM

If the table is not indexed than it will automatically
switch to fast bcp. If the table has index that it 
uses slow bcp.

Vipul

> From owner-sybperl-l@trln.lib.unc.edu Wed Feb 21 09:35:14 1996
> X-Listname: SybPerl Discussion List 
> Warnings-To: <>
> Sender: owner-sybperl-l@trln.lib.unc.edu
> Date: Wed, 21 Feb 1996 07:25:08 -0600
> From: "Doctor, Pranava J."  (Pranava
>       Doctor)
> Reply-To: SYBPERL-L@trln.lib.unc.edu
> To: SYBPERL-L@trln.lib.unc.edu
> Subject: Re: BCP module speed
> Mime-Version: 1.0
> Content-Type> : > text/plain> ; > charset=us-ascii> 
> Content-Length: 893
> 
> SNIP -X- SNIP
> 
> > The upload consists of 10000 rows of 12 fields each, sent in 200 row
> > batches, and there was no index or trigger on the target table, so
> > 'fast' (non-logged) bcp was used.
> >
> 
> Just to clarify my understanding. If you use BCP library, it will always be a
> slow BCP. I thought I read to this effect in the BCP Library manual. I  may be
> wrong.
> 
> Anyone ?
> 
> 
> Pranava.
> 
> 
> 
> -- 
> Every child comes with a message that GOD has not yet given up on mankind.
> 						- Rabindranath Tagore.
> +---------------------------------------+--------------------------------------+
> |Pranava Doctor.			| Norwest Mortgage.		       |
> |1235 11th Street, Apt. 213.		| Midas Dept. Unit # 5386.	       |
> |W. Des Moines, IA 50265-2595.		| 405 SW 5th St., Des Moines,IA 50309  |
> |Tel :(515)267-1107			| Tel :(515)221-4271		       |
> +---------------------------------------+--------------------------------------+
>