On Tue, 12 Aug 2003 16:11:21 +0800, jcheong wrote:

>
> How can I increase the maximum number of connections opened from 25 to 50
> in DBD::Sybase module?

You need to rebuild DBD::Sybase and define MAX_CONNECT to be 50 - edit
dbdimp.c and add

#define MAX_CONNECT 50

somewhere near the top.

That said - do you *really* need 50 connections from the *same* client?
Maybe if you describe why you need to have that many open connections we
can find a different solution...

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler@peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html

On Tue, 12 Aug 2003 15:47:06 +0000, jcheon wrote:

> Michael Peppler wrote:
>
>> On Tue, 12 Aug 2003 16:11:21 +0800, jcheong wrote:
>
>> > How can I increase the maximum number of connections opened from 25 to
>> > 50 in DBD::Sybase module?
>

>> That said - do you *really* need 50 connections from the *same* client?
>> Maybe if you describe why you need to have that many open connections we
>> can find a different solution...
>
> I need to use recursive call of select statement to print out a tree
> structure.

How much data? If each level of the tree isn't excessively large you could
start by loading the data for the top levels, and then taking it from
there...

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler@peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html

thanks!

"Michael Peppler" <mpeppler@bluewin.ch> wrote in message
newsan.2003.08.13.11.40.30.547630@bluewin.ch...
> On Tue, 12 Aug 2003 15:47:06 +0000, jcheon wrote:
>
> > Michael Peppler wrote:
> >
> >> On Tue, 12 Aug 2003 16:11:21 +0800, jcheong wrote:
> >
> >> > How can I increase the maximum number of connections opened from 25
to
> >> > 50 in DBD::Sybase module?
> >
>
> >> That said - do you *really* need 50 connections from the *same* client?
> >> Maybe if you describe why you need to have that many open connections
we
> >> can find a different solution...
> >
> > I need to use recursive call of select statement to print out a tree
> > structure.
>
> How much data? If each level of the tree isn't excessively large you could
> start by loading the data for the top levels, and then taking it from
> there...
>
> Michael
> --
> Michael Peppler Data Migrations, Inc.
> mpeppler@peppler.org http://www.mbay.net/~mpeppler
> Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
> long term contract positions - http://www.mbay.net/~mpeppler/resume.html
>