IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New You're opening a connection for each iteration?
Pooling is where it's at, ma man... :-)
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
New :) It *does* pooling
But it does so optimistically:

1. If there's an (already open) connection in the pool, it gets popped and used.
2. If there isn't a conn ready right away, a new conn is made.
3. When the thread is finished with the conn, it tries to push it into the pool.
4. If the pool is full (mine was max 10), the free conn is closed and discarded.

The 37 connections are far less than the total number of statements. ;) This is *testing* code, ma man.
New Okey Doke
That wasn't entirely clear from the post.

When I use Postgres, I keep my maximum connections very high, on the theory that if I hit a peak once, I'm likely to do it again. Or use a sufficiently slow decay time.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
     Simple ORM data points - (FuManChu) - (4)
         Well, that explains Postgres - (FuManChu) - (3)
             You're opening a connection for each iteration? - (admin) - (2)
                 :) It *does* pooling - (FuManChu) - (1)
                     Okey Doke - (admin)

Beware of things that go blimp in the night...
53 ms