Designing high performance (SQlconnection) Pool

Thread View: borland.public.delphi.language.basm

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Tommi Prami Mon, 28 Apr 2008 06:06

#387

Author: Tommi Prami
Date: Mon, 28 Apr 2008 06:06

23 lines
1769 bytes

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-

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads