Hi,

> > > 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
> > begin
> > with TAQuery.Create(nil) do
> > try
> > SQL.Text := 'SELECT ....';
> > Open;
> > finally
> > Free;
> > end;
> > end;
> >
> > Regards,
> > Arno
>
> I use the same IAQuery. I open and close the query and change the SQL.

Changing the SQL to an complete different query ?
Sounds that IBO let the query prepared and IBX not because you assigned
SQL.Text again.

Regards,
Arno