Subject Re: FB and MSSQL (speed test)
Author rodries2
--- 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
> >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( to connect,
instead of IBX?
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (
> ACCRA Med Software Inc. (


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