WL#3413: Stored Procedures: Compiler

Affects: 7.1 — Status: Un-Assigned — Priority: Very High

Compile stored procedures.

One established way to do this is to translate SQL procedural statements to
valid statements in some other language (such as C), write to a file, call the
compiler for the other language, save a reference to the resultant object file
in mysql.proc, and call it whenever CALL happens. The result should be an
increase in speed, but you need that compiler.

You must be logged in to tag this worklog

EclipseLink was started by a donation of the full source code and test suites of Oracle's TopLink product. This project brings the experience of over 12 years of commercial usage and feature development to the entire Java community. This evolution into an open source project is now complete and developers will soon have access to the EclipseLink 1.0 release. PhD economics AND online doctoral degree AND BS degree

MySQL 6.X splits connection from thread and will support many more connections. You still need one TCP/IP connection per MySQL connection but that will not prevent you from having 10,000+ connections.Business management degree AND management diploma

Tons of thanks!!!!!

business money

Issue bookmarked. Thanks coders!

assurance habitation

Votes

  • Rated 5.00 out of 5
Rated 5.00 out of 5 with 3 votes cast.
You must be logged in to vote.

Watches

2 members are watching this worklog
You must be logged in to track this worklog.

Provide Feedback

Please note:
HTML will be purified, but we allow for a number of HTML tags so that you have the flexibility to decorate your comment text to some extent. The comments allow the following HTML tags:

strong, b, em, blockquote, a, code, pre

To put code into your comment, simply encapsulate your code with
[code language="XXX"][/code], where XXX is any common language, for instance "PHP", "SQL", "C", etc.



You must be logged in to comment