|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: blk_init and image columns
Date: Sep 4 2002 3:05PM
[I'm traveling - currently in England - so email access is spotty... ]
CS_PACKETSIZE must be set in a power of 2, starting at 512 (so 512,
1024, 2048, etc). I think there's a max, and of course the server has to
be configured to handle larger packet sizes (at least up to 12.0 - 12.5
*may* handle this dynamically).
However, I'm pretty sure that the packet size has nothing to do with the
SEGV that you are seeing. I suspect instead that it may be linked with
the TEXTSIZE value. You can set this via SET TEXTSIZE xxxx or via a
ct_option() call.
Michael
On Fri, 2002-08-30 at 13:39, Stephen.Sprague@morganstanley.com wrote:
> sorry. last email for the weekend. I set CS_PACKETSIZE => 9000 via
> CON_PROPS and I still SEGV'ed on the blk_init.
>
> Time to set this thing down and grab a beer.
>
> Cheers,
> Steve
>
>
>
> On Fri, 30 Aug 2002 @ 4:23pm, an entity claiming to be Stephen.Sprague@morg...:
>
> Stephe :Ahhh. Digging further I'm pretty sure this can be solved by increasing
> Stephe :the CS_PACKETSIZE connection property. Now if only I had sa priv to bump
> Stephe :the max size up from 512 on the server...
> Stephe :
> Stephe :Thanks,
> Stephe :Steve
> Stephe :
> Stephe :cf http://www.sybase.com/detail/1,6904,954,00.html
> Stephe :
> Stephe :On most platforms, the packet size defaults to 512 bytes. This default
> Stephe :is provided for backward compatibility. Larger packet sizes 2048 to 4096
> Stephe :bytes, for example almost always yield better performance. This is
> Stephe :generally true for applications that fetch rows with large columns, rows
> Stephe :with lots of columns, or lots of rows with a few small columns. It is
> Stephe :especially true for applications that do bulk copy data transfers or
> Stephe :that handle text and image data.
> Stephe :
> Stephe :To increase a connection's packet size, set the CS_PACKETSIZE connection
> Stephe :property, via ct_con_props, prior to opening the connection.
> Stephe :
> Stephe :--------------------------------------------------------------------------------
> Stephe :Note
> Stephe :You may have to reconfigure SQL Server to accept a larger maximum
> Stephe :network packet size. See the SQL Server System Administration Guide for
> Stephe :instructions on reconfiguring the maximum network packet size.
> Stephe :
> Stephe :
> Stephe :On Fri, 30 Aug 2002 @ 3:34pm, an entity claiming to be Stephen.Sprague@morg...:
> Stephe :
> Stephe :Stephe :hi folks. I'm using Michael's BLK routines to do bulk inserts. Should I
> Stephe :Stephe :be able to use blk_init on a table with an image column?
> Stephe :Stephe :
> Stephe :Stephe :Currently I'm getting a Signal SEGV.
> Stephe :Stephe :
> Stephe :Stephe :Here's the versions:
> Stephe :Stephe : Perl v5.6
> Stephe :Stephe : Sybase::CTlib v2.14
> Stephe :Stephe : OpenClient v12.0
> Stephe :Stephe :
> Stephe :Stephe :I couldn't find any doc to the contrary and I see Sybase's command line
> Stephe :Stephe :bcp references switch -T [image size] so I think it's possible. The question
> Stephe :Stephe :is does the Perl API support something analogous?
> Stephe :Stephe :
> Stephe :Stephe :Any pointers welcome.
> Stephe :Stephe :
> Stephe :Stephe :Thanks,
> Stephe :Stephe :Steve
> Stephe :Stephe :
> Stephe :Stephe :
> Stephe :
> Stephe :
>
>
--
Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!
|
