Subject | Re: [ib-support] FB and MSSQL (speed test) REPOST |
---|---|
Author | Arno Brinkman |
Post date | 2002-09-13T09:36:12Z |
Hi,
For all tests creating new instances ?
for i := 1 to 10000 do
begin
with TAQuery.Create(nil) do
try
SQL.Text := 'SELECT ....';
Open;
finally
Free;
end;
end;
Regards,
Arno
> I post again the results with the next test.How did you test ?
> Doesn't return any record, only open
> and close query many times (12) , How Thomas Miller has said:
> connecting and opening the transaction is what is really being tested.
>
> MSSQL ADO -> ~ 12500 ms
> FB ADO -> ~ 30500 ms
> FB IBX -> ~21500 ms
> FB IBO -> ~11400 ms
>
> The winner is IBO.
For all tests creating new instances ?
for i := 1 to 10000 do
begin
with TAQuery.Create(nil) do
try
SQL.Text := 'SELECT ....';
Open;
finally
Free;
end;
end;
Regards,
Arno