Is HSQL really usable for tables with > 1 Million Rows and databases with over 1 GB ?

----- Original Message -----
From: Rodolfo M. Raya
To: Firebird List
Sent: Friday, March 12, 2004 11:24 PM
Subject: Re: [Firebird-Java] Firebird and The Rest of The World


On Fri, 2004-03-12 at 18:04, Jack Frosch wrote:

> Hello all,
>
> I got this today and wondered if anyone in the Java side of the world
> knows anything about James and why HypersonicSQL would be a better choice
> than Jaybird/Firebird?


Hello,

I started using Interbase when version 4.0 was the greatest thing on
earth. Then I worked with Firebird for a long time and I still use it.
However, it isn't the greatest thing on earth now.

As said, I still use Firebird and still recommend it. But last year I
was asked to add support for HSQL in one of our apps and I tried it.
Surprisingly it is faster then Firebird and easier to use within a Java
program.

Two important points that we observed when comparing Firebird with the
other databases we support (MySQL, HSQL and MS SQL Server):

1) Firebird creates a file and the user must know the path to the
database in order to use it. We had to modify our programs to let the
user enter the path to the database. We prefer to pass a name to the
server and let it handle storage.

2) Firebird was the only database that forced us to alter our code to
create/drop databases. With all the rest database was possible using the
JDBC calls, no need to call administrative classes.

I can say that I hate MS SQL Server JDBC driver, but HSQL was really
easy to use. So easy that I made an RPM (actually two, one for Red Hat
and one for SuSE) and one of my colleagues made an executable installer
for Windows and we offer them for free in our web site.

After a year of intensive use I never had problems with HSQL. No
problems with Firebird either, but differences in performance and the
possibility of developing one code to support MySQL/HSQL and MS SQL
Server at the same time are driving us slowly away from Firebird.

Regards,
Rodolfo



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


[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/Firebird-Java/

b.. To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]