Dan Gowin wrote:
>
> I've just read in DBMS magazine that Oracle, Informix, etc...
> are replacing there proprietary Procedural Language's (PL/SQL) with
> JVMs (JAVA virtual machine). Apparently according to the database
> vendors, this will obviate the need for middle ware products and to
> make CORBA much more intuitive.
This was a problem that I also wanted to talk about.
> My personal opinion is this is yet another mechanism to slow down
> the database engine. I don't mind using JAVA in the database engine
> as a procedural language, but I think there is still great merit in
> breaking
> this out as a separate process (Application Server).
I don't think that it would be slower than PlTcl for example.
Talking about speed:
I made some tests with some procedures written in PlPgsql and PlTcl!
I understood also that PlPgsql is compiling the procedure body into a
sort of bytecodes and the execution is somewhat faster.
In PlTcl, I feel (I didn't poke the sources) that a PlTcl procedure body
is interpreted each time at execution time. For this reason, it doesn't
beneffit from Tcl 8.x compiler, making it slowly than PlPgsql. Am I
right ?
The first question is : Is Tcl 8.x able to precompile a script and
return the bytecodes that should be kept into the database and execute
them later?
>From this point of view, I think that compiling a Java language
procedure and storing the resulting .class might be at execution time as
faster as PlPgsql. And , I think, perfectly possible.
Right now, I am working at a big project using :
1. Tcl/Tk as thin client
2. Messaging server written in Java as a middle-tier with JDBC
3. PostgreSQL RDBMS
It would be perfect from me if PostgreSQL will allow procedures written
in Java language.
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA