Designing high performance (SQlconnection) Pool

Hello,

I think I need to reimplement Inhouse SQLConnection pool. If anyone have good ideas how to make on very fast and and otimizing Locked sections as thin as possible.

Is there any good code for this already out there (which could be easyly used for this).

I need to take care of thread safety, but make it in way that locks are shot and efficient.

I am not too sure what code is actually thread safe. I have only kind of feeling how make thread safe code, but it is just a hunch. Is there any good articles around of this. What is actually thread safe and what is not.

I was thinkin of havin too lists, one for ConnectionObjects in use and one for objects that are free for use.

This way looping trough list and looking for the free Conenction Object would be fast, any ideas???

-TP-
.