Up Prev Next
From: Francois Ochsenbein <francois at vizir dot u-strasbg dot fr>
Subject: Re: Feature request: set maximum number of connections
Date: Jan 27 2004 11:58AM
>Michael Peppler wrote:
>>>I can see that the way to change this is to define MAX_CONNECT in
>>>dbdimp.c. It would be useful to set this limit from Perl somehow.
>>>I looked at the code, but I can't see where syb_init() is being
>>syb_init() is called when the XS boot loader is called (i.e. when
>>DBD::Sybase is "use'd", usually by DBI).
>Ah, I see how this works:
>#define dbd_init syb_init
>>Care to think of ways that the syb_init() function could get this
>>value (consider how it gets the hostname, for example).
>I don't know if it has to be set in syb_init(). Perhaps ctlib will
>be happy to set it later, although before opening the first
>connection. If not, perhaps you'd need something like
> require DBD::Sybase;
> $DBD::Sybase::max_connections = 100;
> use DBI;
> # connect with DBI as normal
>I wouldn't want to put the number into the DBI connection string since
>it is a property of the whole DBD::Sybase library, not one handle.
Yep, this is a parameter to set via sp_configure
(or the SYBASE,cfg file, parameter "number of user connections "),
and reconfigure or restart the server...
Francois Ochsenbein ------ Observatoire Astronomique de Strasbourg
11, rue de l'Universite F-67000 STRASBOURG Phone: +33-(0)390 24 24 29
Email: firstname.lastname@example.org (France) Fax: +33-(0)390 24 24 32