unit ProcPool;

interface

uses
  Classes, Windows, SysUtils, ADODB, forms;

type
  TProcPool = class(TObject)
  private
    FObjList:TThreadList;
    FTimeout: Integer;
    FMaxCount: Integer;
    FSemaphore: Cardinal;
    function CreateNewInstance(List:TList): TADOStoredProc;
    function GetLock(List:TList;Index: Integer): Boolean;
  public
    property Timeout:Integer read FTimeout write FTimeout;
    property MaxCount:Integer read FMaxCount;

    constructor Create(ACapicity:Integer=30);overload;
    destructor Destroy;override;
    function Lock: TADOStoredProc;
    procedure UnLock(var Value: TADOStoredProc);
  end;

var
  ProcPooler: TProcPool;

implementation

constructor TProcPool.Create(ACapicity:Integer=30);
begin
  FObjList:=TThreadList.Create;
  FTimeout := 3000;
  FMaxCount := ACapicity;
  FSemaphore := CreateSemaphore(nil, FMaxCount, FMaxCount, nil);   
end;

function TProcPool.CreateNewInstance(List:TList): TADOStoredProc;
var
  p: TADOStoredProc;
begin
  try
    p := TADOStoredProc.Create(nil);
    p.Tag := 1;
    List.Add(p);
    Result := p;
  except
    Result := nil;
    Exit;
  end;
end;

destructor TProcPool.Destroy;
var
  i: Integer;
  List:TList;
begin
  List:=FObjList.LockList;
  try
    for i := List.Count – 1 downto 0 do
    begin
      TADOStoredProc(List[i]).Free;
    end;
  finally
    FObjList.UnlockList;
  end;
  FObjList.Free;
  FObjList := nil;
  CloseHandle(FSemaphore);
  inherited Destroy;
end;

function TProcPool.GetLock(List:TList;Index: Integer): Boolean;
begin
  try
    Result := TADOStoredProc(List[Index]).Tag = 0;
    if Result then
      TADOStoredProc(List[Index]).Tag := 1;
  except
    Result :=False;
    Exit;
  end;
end;

function TProcPool.Lock: TADOStoredProc;
var
  i: Integer;
  List:TList;
begin
  try
    Result := nil;
    if WaitForSingleObject(FSemaphore, Timeout) = WAIT_FAILED then Exit;
    List:=FObjList.LockList;
    try
      for i := 0 to List.Count – 1 do
      begin
        if GetLock(List,i) then
        begin
          Result := TADOStoredProc(List[i]);
          PostMessage(Application.MainForm.Handle, 8888, 33, 0);
          Exit;
        end;
      end;
      if List.Count < MaxCount then
      begin
        Result := CreateNewInstance(List);
        PostMessage(Application.MainForm.Handle, 8888, 31, 0);
      end;
    finally
      FObjList.UnlockList;
    end;
  except
    Result :=nil;
    Exit;
  end;
end;

procedure TProcPool.Unlock(var Value: TADOStoredProc);
var
  List:TList;
begin
  try
    List:=FObjList.LockList;
    try
      TADOStoredProc(List[List.IndexOf(Value)]).Tag :=0;
      ReleaseSemaphore(FSemaphore, 1, nil);
    finally
      FObjList.UnlockList;
    end;
    PostMessage(Application.MainForm.Handle, 8888, 32, 0);
  except
    Exit;
  end;
end;

initialization
  ProcPooler := TProcPool.Create();
finalization
  FreeAndNil(ProcPooler); 

end.