Convert simple function to MySQL stored procedure

Completed

Description

I have a simple Perl function that queries a MySQL database, performs some basic calculations on the returned data, and returns an array of results. This project is to take the existing Perl function and rewrite it as a MySQL stored procedure that can be called with the same parameters as the Perl function, and then returns a result set. The reason for the rewrite is to test whether there is a performance benefit to running this in the database instead of on the application server.

You must be able to complete this project using only the supplied source code and schema of the involved tables. Database access will not be provided. Because of that, I understand that you will not be able to fully test the stored procedure. That is acceptable as long as the procedure is valid MySQL syntax and is essentially correct.

Skills: PHP, Software Architecture

See more: convert code stored procedure, convert net code sql stored procedure, trigger stored procedure mysql, stored procedure mysql pdf, convert function powerbuilder stored procedure, zip code search mysql stored procedure, stored procedure mysql sharp, stored procedure mysql asp php aspnet, stored procedure mysql filemaker, mssql stored procedure convert, convert sql stored procedure oracle stored procedure, convert stored procedure sql oracle, stored procedure convert function, sql database schema stored procedure

Project ID: #11799989

Awarded to:

JohnNuman

Greetings, Your description is unclear. please share the code. I need to ensure that calculations performed in code are available in SQL as well. Not all the functionality of a programming language can be translated i More

$50 USD in 1 day
(25 Reviews)
5.9