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)