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.

Habilidades: MySQL, Perl

Ver más: trigger stored procedure mysql, stored procedure mysql pdf, stored procedure mysql sharp, postgresql function stored procedure, stored procedure mysql filemaker, loop mysql result set, access code search function, stored procedure schema result, mysql loop result set, stored procedure convert function

Información del empleador:
( 16 comentarios ) Fullerton, United States

ID de proyecto: #11790676

2 los freelancers están ofertando un promedio de $382 para este trabajo.


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 Más

$412 USD en 5 días
(39 comentarios)

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 Más

$352 USD en 3 días
(3 comentarios)