Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve stored procedures performance #4

Open
sanketsarang opened this issue Oct 5, 2018 · 0 comments
Open

Improve stored procedures performance #4

sanketsarang opened this issue Oct 5, 2018 · 0 comments
Labels
enhancement New feature or request hacktoberfest Hacktoberfest

Comments

@sanketsarang
Copy link
Contributor

sanketsarang commented Oct 5, 2018

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request hacktoberfest Hacktoberfest
Projects
None yet
Development

No branches or pull requests

1 participant