Rewrite Perl function as MySQL stored procedure

I have a 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; database access will not be provided. I can provide a schema for the tables that are involved. 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: MySQL, Perl

See more: trigger stored procedure mysql, stored procedure mysql pdf, zip code search mysql stored procedure, stored procedure mysql sharp, postgresql function stored procedure, call stored procedure dial plan mysql asterisk, stored procedure mysql asp php aspnet, stored procedure mysql filemaker, loop mysql result set, microsoft access code search function, access code search function, zip code radius search stored procedure, stored procedure zip code radius search software, stored procedure schema result, zip code search stored procedure, tsql set parameter equal stored procedure value, mysql loop result set, loop mysql result set php, zip code radius stored procedure sql server, schedule stored procedure run result send mail, stored procedure result schema mssql, data access class vbnet stored procedure, stored procedure convert function

About the Employer:
( 16 reviews ) Fullerton, United States

Project ID: #11790676

2 freelancers are bidding on average $382 for this job


Hello,  I am an PHP Developer with more than 7 years of experience and shall get this done in about 5 days' time.  Let me know if you have any doubts / queries about my expertise, will be more than happy to address More

$412 USD in 5 days
(39 Reviews)

Hi I have experience with perl language programming and mysql in linux, so I am confident with this project. What I want to suggest is Mysql doesn't support full SQL syntax, so PostgreSQL is rather preferable. I hop More

$352 USD in 3 days
(3 Reviews)