已关闭

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.

技能: MySQL, Perl

查看更多: 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

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

项目ID: #11790676

2名威客为此工作的平均竞标价是$382

posspooja

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 更多

$412 USD 在5天内
(39条评论)
6.7
sunnysmile911

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 更多

$352 USD 在3天内
(3条评论)
4.4