Hi All,

This is my first topic on this forum. Sorry for my English. I am trying to write SQLJ stored procedures for ORACLE, INFORMIX (J/Foundation).
I have written a procedure for WINDOWS XP in SQLJ and SPL (INFORMIX) that inserts into a table 100000 records. I want to compare the time of the execution the procedure for both cases. Result:

SPL: 9 sec
SQLJ: 150 sec

Why? Why? Why?

Should I do it for UNIX (linux, AIX) to get more reliable results?

Overhead of Java is memory management ,
remenber that JVM manage memory