Hello Talkers
Is there anybody out there - who knows about Java stored procedures?
I can't understand why I get almost the same performance using ODBC from C++ and Stored Procedures. Off-loading to the server should boost performance considerably.
Is there some setup I should check?
4gl procedure: Records 1487, time: 8 sec (running in Procedure Editor, client-side)
Java stored procedure: Records 1487, time: 18 sec (from SQL Explorer, JDBC)
ODBC: Records 1487, time 21 sec (using Merant ODBC from straight C++)
Server: LINUX 9.1c (patch 6)
Client: Win2000 9.1a
Hope some of you can help!
Regards
Mike
Is there anybody out there - who knows about Java stored procedures?
I can't understand why I get almost the same performance using ODBC from C++ and Stored Procedures. Off-loading to the server should boost performance considerably.
Is there some setup I should check?
4gl procedure: Records 1487, time: 8 sec (running in Procedure Editor, client-side)
Java stored procedure: Records 1487, time: 18 sec (from SQL Explorer, JDBC)
ODBC: Records 1487, time 21 sec (using Merant ODBC from straight C++)
Server: LINUX 9.1c (patch 6)
Client: Win2000 9.1a
Hope some of you can help!
Regards
Mike