In Bearbeitung

Convert simple function to MySQL stored procedure

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.

Fähigkeiten: PHP, Softwarearchitektur

Mehr sehen: convert code stored procedure, trigger stored procedure mysql, stored procedure mysql pdf, stored procedure mysql sharp, stored procedure mysql filemaker, mssql stored procedure convert, stored procedure convert function

Über den Arbeitgeber:
( 1 Bewertung ) Kisii, Kenya

Projekt-ID: #11799989

Vergeben an:

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 Mehr

$50 USD in 1 Tag
(25 Bewertungen)
5.9

14 Freelancer bietetn im Durchschnitt $124 für diesen Job an

sveralex

Hello, I've reviewed the script - rather complex! Changed my bid accordingly. -- Thank you. Alexey

$200 USD in 5 Tagen
(122 Bewertungen)
6.0
AdamsK

hi, I am Adams, a full time freelancer proficient in MYSQL. Please post the perl function. Lets start.

$55 USD in 3 Tagen
(75 Bewertungen)
5.6
xielessupport

I can make your project a great success. I'm 31 year old talented PHP and open-source developer. I have 9 years of experience in Server Administration and Web Application Development. I'm expert in web application cust Mehr

$222 USD in 8 Tagen
(18 Bewertungen)
5.1
junaidgulzar0786

I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.

$172 USD in 3 Tagen
(37 Bewertungen)
4.7
filipetrail

Welcome to my introduction, I will be short and sharp as possible. My name is Filip Velickovic and I go by Cofi, currently located in Serbia, south-eastern Europe. Young free-lancer willing to work and lusting for Mehr

$45 USD in 3 Tagen
(4 Bewertungen)
4.2
vw7209238vw

Hello, I am sure I can solve your situation. I am specialized in databases design and programming. Have wide experience in Mysql and strore procedures developing. Please contact to give you the solution with success. Mehr

$50 USD in 0 Tagen
(15 Bewertungen)
4.5
robertkjr3d

The text file you have above shows the table structure. But the Perl source code is not there yet. So I'm assuming that would be given after someone that is me wins the bid. I would produce a 'Create Stored Proc Mehr

$250 USD in 3 Tagen
(3 Bewertungen)
3.4
djcarras

hi, i can help you with your project. i need the structure of tables that uses in your querys. send me more information about via freelancer.com chat. regards

$166 USD in 1 Tag
(2 Bewertungen)
2.4
CoderField

Hi, I’m dedicated professional Web and Desktop Programmer & Developer and freelancer only. I have been working with challenge and hope to improve future plan with good network every client. If any client want to get Mehr

$155 USD in 3 Tagen
(3 Bewertungen)
2.4
$49 USD in 2 Tagen
(3 Bewertungen)
2.4
serxanbayramli

Hi, I'm currently working as a Software Developer at IBM and have 3 years of experience with Web Development and databases. I would be glad to help you. Please contact me if you have any questions. Best, Sark Mehr

$200 USD in 3 Tagen
(2 Bewertungen)
1.8
$30 USD in 3 Tagen
(1 Bewertung)
0.4
neo2512

Hello Sir, I have a good knowledge of SQL queries and procedures but i'll be honest with you i don't have much knowledge of PERL but given my background of Advanc JAVA C,C++ and python i wont have much trouble knowing Mehr

$133 USD in 3 Tagen
(0 Bewertungen)
0.0
sachinaarya

Dear Hiring Manager, When You Assign the Project than we will start. My Level Of English is Very Good. I have expertise on Php,Joomla,Magento,CI And wordpress. I have more than 7+ year of experience with Php, Mehr

$388 USD in 7 Tagen
(0 Bewertungen)
0.0
techwizards3

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c Mehr

$200 USD in 7 Tagen
(1 Bewertung)
0.0
noahlabs

Look, I've been doing mysql database for years. I've written dozens of stored procedures. I've worked directly with mysql employees themselves from Europe. Let me take care of this for you.

$111 USD in 2 Tagen
(0 Bewertungen)
0.0
creative4soft

Hello Mate We are a young team that is focused on growth through doing things differently. Since inception we have focused on delivering projects which are benchmarked by its quality. We say what we can deliver and d Mehr

$112 USD in 3 Tagen
(0 Bewertungen)
0.0