Improve my MySQL stored procedure

Imekamilika Ilichapishwa Miaka 6 iliyopita Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

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!

Usimamizi wa Uhifadhi Data Ujenzi wa Database Kuprogramu Database MySQL PHP

Kitambulisho cha Mradi: #15644552

Kuhusu mradi

22 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

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 Zaidi

$263 AUD kwa siku 5
(Maoni 1204)
9.4

22 wafanyakazi huru wanazabuni wastani wa $177 kwa kazi hii

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 Zaidi

$250 AUD kwa siku 6
(Maoni 518)
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 Zaidi

$171 AUD kwa siku 3
(Maoni 525)
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 Zaidi

$150 AUD kwa siku 5
(Maoni 93)
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 kwa siku 3
(Maoni 81)
6.3
rajan6533

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

$45 AUD kwa siku 2
(Maoni 11)
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 Zaidi

$150 AUD kwa siku 7
(Maoni 9)
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 Zaidi

$138 AUD kwa siku 4
(Maoni 9)
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 kwa siku 3
(Maoni 3)
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 Zaidi

$40 AUD kwa siku 4
(Maoni 0)
0.0
RaqiyaTawfeeq

A proposal has not yet been provided

$30 AUD kwa siku 3
(Maoni 0)
1.9