Re: [Firebird-Java] Re: Firebird and The Rest of The World
Rodolfo M. Raya
On Mon, 2004-03-15 at 21:11, Roman Rokytskyy wrote:
> 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.