On Mon, 2004-03-15 at 21:11, Roman Rokytskyy wrote:

Hello Roman,

> Point about creating databases taken. I have currently problems
> executing isc_execute_immediate call that would provide the same
> interface for the Firebird. For some reasons it crashes the server.

What we need is something very simple: use a SQL statement to create a
database and let the server decide where to store it. We want to pass a
database name (only the name, not a file name) and expect the server to
create the database in its own folder. Something as simple as:

"CREATE DATABASE TRANSDB"


> However, I did some testing with HSQLDB and cannot share your
> optimism. I tried AS3AP benchmark suite in two modes - in-memory
> tables and cached tables.

We did not run any specialised benchmark. A common user of our
application does the following:

- create a database
- insert 10,000 ~ 50,000 records
- do some searches (1,000 or less)
- remove the database or forget about it

Second step is where we noticed the differences. I had to tweak index
definitions and make some special adjustments to let Firebird perform as
fast as HSQL or MySQL.

You did a great work with the driver Roman. I believe the issues that
bother us are not related to JDBC. Our usage problems seem related to
database server design.

Regards,
Rodolfo

--
Rodolfo M. Raya <rmraya@...>
Maxprograms