db
db copied to clipboard
Improve stored procedures performance
Today stored procedures communicate with the database using a TCP connection over the LAN. This connection is typically over localhost and is hence fast, but some time in lost in serialising and deserialising data over the TCP protocol. To get utmost performance, since the stored procedures are loaded as Java code, they should be able to invoke DB functions (like fire a SQL query) using Java reflection. This bypasses any TCP connection requirements and would be the utmost use of available hardware.
Bounty: $300 (Read contributors agreement)