Advertisement
jaclas

Untitled

Feb 26th, 2020
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. var
  2. lSQL: string;
  3. lLogTimer : TLogTimer;
  4. lStr: string;
  5. t1, t2, t3: LongInt;
  6. begin
  7. lLogTimer := TLogTimer.Create;
  8. try
  9. dbFB.Connected := True;
  10. lSQL := 'SELECT OPCJA, WARTOSC, IDUZYTKOWNIKA FROM KONFIGURACJA WHERE (IDUZYTKOWNIKA=0 OR ' +
  11. 'IDUZYTKOWNIKA=:IDMASZYNY OR IDUZYTKOWNIKA=:IDUZYTKOWNIKA)';
  12. t1 := lLogTimer.WorkingTime;
  13. dsFB.close;
  14. dsFB.selectSQL.Text := lSQL;
  15. dsFB.ParamByName('IDUZYTKOWNIKA').AsInteger := 3;
  16. dsFB.ParamByName('IDMASZYNY').AsInteger := 0;//TrgCrypt.CRC32AsInteger(TrgMachine.ComputerName); // maszyna, MAC karty sieciowej
  17. dsFB.Open;
  18.  
  19. t2 := lLogTimer.WorkingTime;
  20.  
  21. dsFB.FetchAll;
  22. t3 := lLogTimer.WorkingTime;
  23.  
  24. while not dsFB.EOF do
  25. begin
  26. lStr := dsFB.FieldByName('OPCJA').AsString + ' ' + IntToStr(dsFB.FieldByName('IDUZYTKOWNIKA').AsInteger);
  27. dsFB.Next;
  28. end;
  29. finally
  30. lLogTimer.Free;
  31. end;
  32. mmo1.Lines.Add(Format('t1 = %d ms; t2 = %d ms; t3 = %d ms; recs = %d', [t1, t2, t3, dsFB.RecordCount]));
  33. dsFB.Close;
  34. dbFB.ForceClose;
  35. dbFB.Connected := False;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement