I have tested most of the other options Hypersonic, Firebird, Daffodil
and Postgres is much faster with large data sets and a lot better on
memory usage. I have not tried Cloudscape as that was only very recently
released under a license that would allow me to embed it. The query
times with Postgres are in the 1-5sec range comparing to 30sec plus on
the others. Hypersonic can be quick but only with the entire table in
memory, gets nasty with outer joins.
Are there are any I haven't tried and should be looking at?
I am using Hibernate as a middle layer so porting should not be an issue.
Thanks
Jasper
Kris Jurka wrote:
>On Sun, 16 Jan 2005, Jasper Potts wrote:
>
>
>
>>Is there a way of creating a JDBC connection to the db not over a
>>network socket?
>>
>>
>
>No. Java does not have support for unix sockets.
>
>
>
>>The other way is going to be to start/stop the database from Java by
>>calling "pg_ctl start/stop". But that issues with this because of the
>>windows restrictions that postgres can't be run as a user with admin
>>privileges. Any Ideas?
>>
>>
>>
>
>Even if Java did support unix sockets you would still have to start the
>server running. PostgreSQL is not designed to be an embedded database
>(especially not by Java). This doesn't seem like a great idea, perhaps
>one of the Java databases would be more appropriate for this task?
>
>Kris Jurka
>
>