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: Specification of Packet Size
Date: Jun 27 1998 2:52PM

Simon Yaminian writes:
 > 
 > > 
 > > Curtis Johnson writes:
 > >  > Hi All,
 > >  > Is there a way to specify the sybase network packet size
 > >  > before connecting with either CTlib or DBlib versions of
 > >  > sybperl?
 > > 
 > > DBSETLPACKET() for DBlib.
 > > 
 > > For CTlib, you'd do:
 > > 
 > > $dbh = new Sybase::CTlib user, pwd, server, appname, {CON_PROPS =>
 > > {CS_PACKETSIZE => 1024}};
 > > 
 > > This requires a fairly recent version of sybperl.
 > > 
 > > Michael
 > > -- 
 > > Michael Peppler         -||-  Data Migrations Inc.
 > > mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
 > > Int. Sybase User Group  -||-  http://www.isug.com
 > > 
 > > 
 > Hello,
 >    I would like to know what the default is for the DBlib packet size and 
 > what effect it's change would have on the retrieval process. Specifically on 
 > the dbsqlexec and dbresults calls? In addition what version of Sybperl this
 > is effective on?

The default packet size is 512 bytes. The DBlib DBSETLPACKET() call
has been around for a while (probably since 2.05 or so). The CTlib
version since 2.07 (or maybe 2.08).

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com