List:MySQL and Java« Previous MessageNext Message »
From:Peter Schäfer Date:January 20 2003 8:39pm
Subject:RE: JDBC Interface for Embedded Server ?
View as plain text  

> -----Ursprüngliche Nachricht-----
> Von: Mark Matthews [mailto:mmatthew@stripped]
> Gesendet: Montag, 20. Januar 2003 19:03
> An: Tim Endres
> Cc: java@stripped
> Betreff: Re: JDBC Interface for Embedded Server ?
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Tim Endres wrote:
> >>1. It will probably be slower than just embedding a 'normal' MySQL
> >>server with your application, because of JNI call overhead.
> >
> > When you say this, do you mean to embed a MySQL server and connect
> > to it using JDBC? Do you know anyone who has done this?
>
> Yes. I've heard of people doing it, but I don't have a list of names or
> anything :)

OK, here I am ;-)

>
> You can manage server startup/shutdown via Runtime.exec(), and you can

This is exactly what I do right now.
It works pretty well, and is also quite fast.

(have a look here:
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jose-chess/src/de/jose/db/MyS
QLAdapter.java?rev=1.1.1.2&content-type=text/vnd.viewcvs-markup)

However, I thought that it could be even faster if one could eliminate
the "network" connection.

JNI requires some overhead, too, but do you really think it would be
slower than a socket connection ?!?

-- Peter

Thread
JDBC Interface for Embedded Server ?Peter Schäfer20 Jan
  • Re: JDBC Interface for Embedded Server ?Mark Robson20 Jan
  • Re: JDBC Interface for Embedded Server ?raffi@dcit.com20 Jan
    • Re: JDBC Interface for Embedded Server ?Mark Matthews20 Jan
      • Re: JDBC Interface for Embedded Server ?Tim Endres20 Jan
        • Re: JDBC Interface for Embedded Server ?Mark Matthews20 Jan
          • RE: JDBC Interface for Embedded Server ?Peter Schäfer20 Jan
            • Re: JDBC Interface for Embedded Server ?Mark Matthews20 Jan
      • Re: JDBC Interface for Embedded Server ?raffi@dcit.com21 Jan
        • Re: JDBC Interface for Embedded Server ?Mark Matthews21 Jan
      • JDBC RealmFrank Daly27 May
RE: JDBC Interface for Embedded Server ?Peter Schäfer20 Jan