From: | Jasper Potts <jasper(at)squarepark(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Embedding Postgres in Java Application |
Date: | 2005-01-16 16:41:51 |
Message-ID: | 41EA994F.3000207@squarepark.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2005-01-16 19:39:36 | Re: Embedding Postgres in Java Application |
Previous Message | Kris Jurka | 2005-01-16 16:32:20 | Re: Embedding Postgres in Java Application |