Improve my MySQL stored procedure
$30-250 AUD
货到付款
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!
项目ID： #15644552
关于项目
有22名威客正在参与此工作的竞标，均价$177/小时
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 更多
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 更多
hi There is no problem with your requirements. I can do the work. I have extensive experience in mysql development
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 更多
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 更多
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
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 更多
