How best to implement connection pooling?

[jamesdboggs]

I am suggesting that connection pooling be implemented in Oracle on our 3 tier system: an Oracle 9i database on an NT server, a middle tier application web server on IIS (using Active Server pages with VBScripts and JScripts) with clients accessing from their PC's over the web. I suggested implementing connection pooling and shared servers(MTS in 9i) on the Oracle server, others have suggested implementing connection pooling on the application web server within the asp pages (wouldn't this require much more coding?), or implementing connection pooling on the Microsoft O/S of the application web server.

Which method is best suited for performance?
Is there any comparative papers that document this?

Thanks

 

[pgirl]

Hi there,

There's a very good article with some comparative testing located here:

http://www.15seconds.com/issue/010814.htm

Good luck