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?