|Subject||Re: FB and MSSQL (speed test) REPOST|
--- In ib-support@y..., "Arno Brinkman" <firebird@a...> wrote:
> > I post again the results with the next 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
> >I use the same IAQuery. I open and close the query and change the SQL.
> > MSSQL ADO -> ~ 12500 ms
> > FB ADO -> ~ 30500 ms
> > FB IBX -> ~21500 ms
> > FB IBO -> ~11400 ms
> > The winner is IBO.
> How did you test ?
> For all tests creating new instances ?
> for i := 1 to 10000 do
> with TAQuery.Create(nil) do
> SQL.Text := 'SELECT ....';