--- In ib-support@y..., Daniel Rail <daniel@a...> wrote:

> At 11/09/2002 12:26 PM, you wrote:
> >I'm doing some test using FB (with IBX and ADO) and MSSQK (with

ADO)

> >and I've seen that MSSQL is faster than FB when I open query's.
> >My program test open 12 querys that return only 1 row an th result
> >are:
> >MSSQL ADO -> ~ 12500 ms
> >FB ADO -> ~ 30500 ms
> >FB IBX -> ~21500 ms
> >
> >The test is over a internet conection (2 DSL 256k) and I've done it
> >10 times.
> >I suppose that FB spent more time open a query than MSSQL, is this
> >true?
> >
> >I've used zebedee too, but without any speed gain.
> >
> >How can I accelerate then open of querys?
>
> Have you tried using IB Objects(www.ibobjects.com) to connect,

instead of IBX?

>
>
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.accramed.ca)

Hi

The problem is that I'm using BCB 6 and I can't test it with the
eval, but I don't think the problem is the database access component.

You can test open and close a query many times and compare the time
that spent the program ( I use GetTickCount) using FB and MSSQL