Subject Re: [ib-support] Firebird - slow queries
Author Paul Reeves
On Mon, 13 May 2002 15:57:46 +0200, Roodie wrote:

>The server: a linux box, 512 ram, p-III-600, lots of disk
> space. Database servers: Postgres 7.2, mysql. 3.22,
> Firebird 1.0. All freshly installed, only with the test
> database

Which version of Firebird - Classic or SuperServer?

>I kept this simple, I just wanted a quick test.
>The test program was a small php application
>(php 4.1.1 using AdoDB 1.99, on the same
>linux box)

How does the Firebird driver handle connections, transactions and preparation of statements.

For this sort of test Firebird would look a lot better if
a) the connection persists
b) Commit Retaining is used for the Select queries
c) The Select query is prepared once before execution.

I'm not familiar with AdoDB so I don't know how much is generic to all supported databases and how much is driver specific. If it is a well designed middleware layer it will allow the driver developer to surface all the above functionality. Whether the driver developer has implemented it all is another matter.

Paul Reeves
Supporting users of Firebird and InterBase