I don't see any resource limiting there. In fact LaDBI doesn't even support
any to my knowledge, you have to do it yourself. Obviously nothing is
stopping the sessions you are creating from trying to open too many
connections. You're just creating 300 sessions and indescriminantly asking
LaDBI to open a connection for each one.
Additionally: Your _start states post, which means they return before they
start doing what they are supposed to. This is one of the points of
programming in POE, and I'm not sure if you understand that, but you're
calling _start 300 times before you're getting a chance for _stop to happen
once, so I don't know what makes you think that there would be less than 300
connections being attempted at once.
Since that's exactly what you're telling POE and LaDBI to do:
create 300 sessions
wait for connections.
- Scott
On 5/5/05, Alex <[EMAIL PROTECTED]> wrote:
>
> yes,
> j - 2 iterations
> i - 150 iterations
> 150*2= 300 :)
>
> double loop is just for 'sleep 1'
>
> Maximum there must be not more than 197 connections, i
> don`t know why didn`t poe kill connection after DBI
> operation, after _stop function connection is still alive.
> Why? I don`t know :(
>
> I tried ladbi, simpledbi modules - the same errors :( Can
> anyone help me ?
>
> thank you
>
> > You start out by creating 298 sessions? j=1 less than 3,
> >is two
> > iterations, two times i=1 less than or equal to 150 is
> >298? This happens
> > before you even start the kernel...
> >
> > Why the double loop anyways?
> >
> > for my $i (0..195) {
> > ...
> > }
> >
> >>
> >> Code below:
> >> ________________________
> >>
> >> ...
> >> use constant LADBI => "ladbi";
> >> POE::Component::LaDBI->create( Alias => LADBI );
> >> my $r;
> >> for(my $j=1;$j<3;$j++)
> >> {
> >> for(my $i=1;$i<=150;$i++)
> >> {
> >> POE::Component::My::DBI->spawn(SQL => $SQL,EVENT =>
> >>"insert");
> >> print "$j : $i\n";
> >> }
> >> sleep 1;
> >> }
> >> $poe_kernel->run;
> >> exit 0;
> >>
> >
> > [snip]
> >
> > http://danconia.org
>
> ---
> Professional hosting for everyone - http://www.host.ru
>
