Improve my MySQL stored procedure

Terminé Publié le il y a 6 ans Paiement à la livraison
Terminé Paiement à la livraison

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!

Administration de Bases de données Développement de bases de données Programmation de bases de données MySQL PHP

Nº du projet : #15644552

À propos du projet

22 propositions Projet à distance Actif il y a 6 ans

Décerné à:

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 5 jours
(1204 Commentaires)
9.4

22 freelances font une offre moyenne de 177 $ pour ce travail

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 Plus

$250 AUD en 6 jours
(518 Commentaires)
9.2
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 Plus

$171 AUD en 3 jours
(525 Commentaires)
8.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 Plus

$150 AUD en 5 jours
(93 Commentaires)
6.3
i2software

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

$222 AUD en 3 jours
(81 Commentaires)
6.3
rajan6533

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

$45 AUD en 2 jours
(11 Commentaires)
3.2
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 Plus

$150 AUD en 7 jours
(9 Commentaires)
3.5
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 Plus

$138 AUD en 4 jours
(9 Commentaires)
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 en 3 jours
(3 Commentaires)
2.4
ITprogrammer1

Hello! I am writing in response to your Project. After carefully reviewing the experience requirements and skills required for the job, I feel that I am a suitable match for the job. I am a data scientist by professi Plus

$40 AUD en 4 jours
(0 Commentaires)
0.0
RaqiyaTawfeeq

A proposal has not yet been provided

$30 AUD en 3 jours
(0 Commentaires)
1.9