Find Jobs
Hire Freelancers

Convert simple function to MySQL stored procedure

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 11799989

About the project

14 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 into SQL script. In the meanwhile, I'd encourage you to take a moment to review recommendations by my current clients to learn about my work ethics and professionalism. Some of them are from your own country of origin. Let's get it started and have it done!
$50 USD in 1 day
5.0 (25 reviews)
5.9
5.9
14 freelancers are bidding on average $124 USD for this job
User Avatar
Hello, I've reviewed the script - rather complex! Changed my bid accordingly. -- Thank you. Alexey
$200 USD in 5 days
5.0 (122 reviews)
6.0
6.0
User Avatar
hi, I am Adams, a full time freelancer proficient in MYSQL. Please post the perl function. Lets start.
$55 USD in 3 days
4.9 (75 reviews)
5.6
5.6
User Avatar
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 days
5.0 (37 reviews)
4.7
4.7
User Avatar
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. Please review my profile and comments from my clients as a reference.
$50 USD in 0 day
4.8 (15 reviews)
4.5
4.5
User Avatar
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 more and more job opportunities. I have 5 years of professional web-developing and Web Design experience and some side-programming languages. I'm currently employed as a web developer & a supporter on E-Trail game & web hosting, and free-lancing in the same time, Not sure if you want to know about my hobies but here they are: Computers(yeah), phones, cats (dogs if you are a dog person), food, beer, exquisite wine and i also like to experiment a lot with the new features that we are bestowed upon on a daily basis. My Developing history is fairly rich I might say, since I am followed by many big private projects in these 5 years of professional development. Most of the codes i have written and i do write currently are coded in HTML5,CSS3, jQuery, AjaX, MySQL since those are the fields that I'm experienced in, that being said you can be assured that I can and I will make anything that you desire POSSIBLE. I hope for a positive outcome and a successful business with you, Best regards, Filip Velickovic.
$45 USD in 3 days
5.0 (4 reviews)
4.2
4.2
User Avatar
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 Procedure' code for you to run in your MySQL, that would run on your MySQL DB. If the Perl-Code appears complicated enough, meaning if it's possible that there are two ways to go about doing the insert. I might give you two different versions for you to see which one is faster. It sounded as if, that it was pretty simple code though. As in... Take the inputs to the procedure, so then insert into the table(s) here. Let me know... I know there are lot of bidders you have to sort through. Talk to you later. My name is Robert.
$250 USD in 3 days
4.8 (3 reviews)
3.4
3.4
User Avatar
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 more faster job services with save time I am ready to work. I can ensure that I’ll complete each instruction within time frame even more faster. I am available everyday to work more than 12 hours. I can ensure that I'll complete each instruction within time limit with daily update on server. I am ready to work and I hope I'll get permit to prove my experience. Thank you
$155 USD in 3 days
4.7 (3 reviews)
2.4
2.4
User Avatar
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 day
5.0 (2 reviews)
2.4
2.4
User Avatar
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, Sarkhan
$200 USD in 3 days
5.0 (2 reviews)
1.8
1.8
User Avatar
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 it and thus quite apt in completing the said project.
$133 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 deliver what we commit. We have understand your requirement based on that we have dedicated team to serve your project needs. We have accomplished such tasks in the past also though its a new venture for us on this platform so you wont be able to find many reviews. But we assure you as your project needs to get transformed from good to great, we hopefully will not let your expectation down.
$112 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 checked your requirements.i have right skills to work on this assignment my award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. can u provide your email or sky-pe etc for further discussion about the project. I am ready to discuss with you with best Regards
$200 USD in 7 days
0.0 (1 review)
0.0
0.0
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of KENYA
Kisii, Kenya
5.0
1
Payment method verified
Member since Feb 25, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.