Cancelled

Improve my MySQL stored procedure

Hi there,

I'm looking for a MySQL and PHP expert to improve a stored procedure running on my database. This stored procedure checks two values in a table, and if one value is less than another value, it increases the lesser value every second using a sleep statement until it equals the greater value, then quits.

The scripts and functionality do work currently, however there is a problem: in some scenarios too many threads are created when the stored procedure runs, and they are not killed at the end of the stored procedure.

Also, there are some scenarios where the stored procedure simply doesn't run due to an "incrementing" column I have in the database, which it checks first before running. Unfortunately if incrementing == true, but the two values are not the same, the stored procedure never runs.

I have some requirements for this project. Please read them carefully and ensure you only bid if you can comply with the following:

- I need this solution to work on a shared host, not a VPS or my own server

- You must use your own environment to develop and test your code - I cannot give you any access to my servers

- I would prefer that the solution uses a stored procedure and works similarly to the logic already defined

- The solution MUST close all database connections when the stored procedure terminates

- The solution MUST close all PHP threads/processes associated with the scripts

- The solution MUST close all MySQL threads/processes on completion

- The logic must ensure no conflicts are possible (e.g. the incrementing script should never run twice)

- The solution must have graceful error handling and fall-back

I will supply the winning bidder with the relevant parts of the client code (HTML5/JavaScript) as well as the PHP scripts, SQL stored procedure and database table schemas. You should read the scripts and understand what the functionality is trying to do. My preference is that you fix and improve my scripts, however if you have a better solution that is guaranteed to work, I am open to using it - as long as there is not too much integration required on my end.

Good luck, and happy bidding!

Skills: Database Administration, Database Development, Database Programming, MySQL, PHP

See more: mysql stored function example, how to call a function in mysql stored procedure, how to improve performance of stored procedure in mysql, optimizing mysql stored procedures, execute function in mysql workbench, how to call function in mysql, mysql stored procedure performance tuning, mysql function example with parameters, mysql stored procedure freelance, mysql stored procedure that checks if tables are present in database, mysql stored procedure, mysql stored procedure pdf, php mysql stored procedure coding, mysql hierarchical tree stored procedure, mysql stored procedure slow performance

About the Employer:
( 35 reviews ) Sydney, Australia

Project ID: #15644552

Awarded to:

rinsadsl

hi... we have done many project in PHP / MySQL as well as in Stored procedure. We can help you on this Relevant Skills and Experience MySQL stored procedure, PHP Proposed Milestones $100 AUD - Initial $163 AUD - On c More

$263 AUD in 5 days
(901 Reviews)
8.6

28 freelancers are bidding on average $175 for this job

monitrix

Hi, Would help you to improve stored procedure as per given requirement. Can we discuss your requirement in brief so that I clear my queries. Lets have a chat for detail discussion. ThankS Relevant Skills and Experien More

$250 AUD in 6 days
(319 Reviews)
8.4
OutsourceMan

Yes, We have 10+ years experience with MySQL and PHP Surely, We are ready to help you with improve a stored procedure running on your database. Let discuss little more? We will offer you the best. Relevant Skills and More

$171 AUD in 3 days
(232 Reviews)
7.8
vtechiti

Dear employer, I have gone through your requirement to Improve my MySQL stored procedure and will be glad to work for you. Relevant Skills and Experience Please take a look of some of the website done by me: http: More

$200 AUD in 7 days
(370 Reviews)
7.5
iquallinfo

Yes, I can improve your MySQL stored procedure. I have good experienced on PHP, MySQL Database. May we discuss few points quickly? For more details:- [url removed, login to view] Relevant Skills and Experience My recent w More

$150 AUD in 5 days
(113 Reviews)
7.0
hjabeen972

I am experienced with PHP / angular.JS MYSQL , WORDPRESS , OPENCART , PHP/codeigniter , HTML , CSS , HTML5 , CSS3 , JQUERY , JAVASCRIPT , PHOTOSHOP Relevant Skills and Experience [url removed, login to view] More

$136 AUD in 3 days
(118 Reviews)
6.7
i2software

hi There is no problem with your requirements. I can do the work. I have extensive experience in mysql development

$222 AUD in 3 days
(81 Reviews)
6.2
hunmin888

A proposal has not yet been provided

$222 AUD in 3 days
(15 Reviews)
5.5
$200 AUD in 3 days
(13 Reviews)
4.8
saritamahar

Hello, I have 6+ years exp in WordPress, PHP, and MySQL. Please enable chat to share more details. Eagerly waiting for your response. Regards: Sarita Mahar Relevant Skills and Experience WordPress, PHP Proposed Mi More

$150 AUD in 5 days
(37 Reviews)
4.8
STPLSRM

Hello, I assure you to improve your Database structure as per need. As I see you need an Expert Developer. I am 8+ year experienced in Web and App Development (Native & Hybrid),and Designing. Relevant Skills More

$555 AUD in 3 days
(3 Reviews)
5.2
Webbleu

Hello Dear Client, We have gone through your requirement and would to take this opportunity to work on this project. Can you send a detailed requirement about your project. Relevant Skills and Experience We have bee More

$155 AUD in 3 days
(27 Reviews)
4.5
dunitech

Hey There !! We have seen the job post of yours and very interested to start work with you as we have delivered out the similar kind of project I am having major 11+ years experience in PHP PHP5 HTML5 CSS3 Shopify More

$155 AUD in 3 days
(3 Reviews)
4.2
seefattechnologi

Hello, Hope you are doing well!! I have read and gone through your requirements which states that you are in need of an experienced PHP developer so here I am having 5+ years of experience in web development as wel More

$201 AUD in 3 days
(6 Reviews)
3.8
caperaservices

aI'm a web and app developer with 5 years experience in php, MySQL, CSS3, HTML 5,android and WordPress, WP plugins, and 3rd party API shopping engines, etc. Relevant Skills and Experience [url removed, login to view] More

$250 AUD in 3 days
(4 Reviews)
3.6
suninfolabs

Dear sir, I have a team of expert developer and designer who can give make any kind of application with their skill set. I have seen requirements and I am 100 % sure that I can make it happened with latest design More

$150 AUD in 7 days
(4 Reviews)
2.7
rajan6533

i will do it Relevant Skills and Experience mysql Proposed Milestones $45 AUD - sone

$45 AUD in 2 days
(3 Reviews)
2.4
ashishkathiriya

Hello sir, I have good experience in php and mysql. I have more than 5 years experience in this field. Looking forward to hear from you. Thanks Ashish Relevant Skills and Experience PHP Mysql Proposed Milestones $1 More

$138 AUD in 4 days
(9 Reviews)
2.5
reddysir2016

We have done so many data base administration projects Relevant Skills and Experience Database Administration, Database Development, Database Programming, MySQL, PHP Proposed Milestones $155 AUD - on chat

$155 AUD in 3 days
(3 Reviews)
2.4
digitalyzers

Dear Sir, We have 6+ years of extensive experience in website designing and development. We are a team of go getters that have successfully executed numerous turnkey projects for different clients all around the glo More

$45 AUD in 3 days
(2 Reviews)
2.0
$97 AUD in 3 days
(2 Reviews)
2.4