Fix php mysql big table problem.

Hello There 2 solution for this task. #1 - the way of efficient mysql conenction. #2 - DB config settings. That's it

I have read the description and I can fix the table problem in PHP as per your requirements. I can do it asap.

Hello, if you give me database then i shall show you first process in my local machine. after that you implement in your machine. Thanks

hello, Hope you are doing well. I have understood the requirements, just want to clear some points. Message me when you are free. I have been working as a developer since 10 years. thanks

Hello, I think I can help you with this. Having 10+ years working on PHP/MySQL projects - I've seen a lot of performance issues and have a good knowledge of how to get that improved. For you problem to be solved - I would like to discuss how it is being used as I find that script that you have attached somewhat strange. And based on that - I'll find a solution. With regards Viktor

Hi I am working on latest web technologies for more than 5 yrs. I have extensive experience in php,mysql. I can fix your issue to run this script in timely manner. My goal is to achieve client's satisfaction. Ready for your work. We can discuss more details in chat now. Thanks

Hello, I have gone through your requirements and understand what you need. I am a Web developer with 7 years experience I have used a lot of technology to implement my clients solutions. List of Services that i can help you - Build custome web applications using Native PHP with all php versions - Build custome web applications using PHP Frameworks ( Codeigniter - Laravel - Cakephp) - Using PHP CMS ( Wordpress - Drupal - Joomla) - Website Management - Server or Website maintenance and technical support - Data Scraping - RestAPI - SDK ( google map - Facebook - Twilio ) - Version control using (Git - Bitbucket) I look forward to speaking with you about this opportunity. I'm mostly on the internet, we can talk there in a fast way. Thanks & Regards Elia Fawzy

Hello, i can do it for you. Please contact me and i help. Regards, Alex.

5 years experience in Reactjs / Redux / Angular / Nodejs / PHP / Django / Backned - Frontend development! All of our programming skills: *Front-end: - HTML, HTML5, JSON. - JAVASCRIPT (Ajax, AngularJS / 2 / 4 / 5 / 6 / 7, ReactJS - Redux, Jquery). - CSS, CSS3, Twitter Bootstrap, Less, Sass, Scss, Responsive, Material. - Mobile apps: React Native, Swift, ObjectiveC. - Page speed optimize *Backend Skills: - Python (Django), ROR, PHP (Framework : CAKEPHP, Yii, Laravel, Ci), Node.js. - MVC, OOP, CURL, MongoDB, Postgres, MySQL, Rest APIs. *Other skills: - Git, Heroku, SVN, Bitbucket, HG, Linux, Mac - Vagrant, VirtualBox, Gulp, Grunt - AMZ S3, AWS EC2 FREE support after delivery up to 4-6 weeks4 years experience in Reactjs / Redux / Angular / Nodejs / PHP / Django / Backned - Frontend development!

Hi, I have 8 years of experience and working on hadoop, spark, nosql, java, BI tools(tableau, powerbi), cloud(Amazon, Google, Microsoft Azure)... Done end to end data warehouse management projects on aws cloud with hadoop, hive, spark and presodb. Worked on multiple etl project like springboot, angular, node, PHP, Kafka, nifi, flume, mapreduce, spark with XML/JSON., Cassandra, mongodb, hbase, redis, oracle, sap hana, ASE.... Many more. Let's discuss the required things in detail. I am committed to work done and strong in issue resolving as well. Thanks

Hi there! I’m a professional developer with 7+ years of experience. I'm honesty, communicable, responsible and passionate about programming holding my hand on a pulse of a new technologies every day. My top priority is getting the project finished on time with quality, well structured and easy maintainable code. I'm trying to bring all my work to perfection. If it is what you are looking for, I will be glad to work with you! Best Regards

I presume that there is a block missing from your code that does something with the data between fetching the row and updating it. To improve concurrency in this, you will need to avoid the table locking. I suggest something along the following lines: 1) Add a column to contain a UUID 2) UPDATE spw SET uuid = '<uuid you just randomly generated>' WHERE sent = 0 AND uuid IS NULL LIMIT 200; 3) SELECT * FROM spw WHERE uuid = '<uuid you just set in 2)>'; 4) Process the data 5) UPDATE spw SET sent = 1 WHERE id = $row[0]; That will avoid the need for any locking and give you much better concurrency. There are various additional tuning options you can apply to improve performance in this scenario and avoid deadlocks, which I would be happy to discuss. I have 20 years of experience with MySQL and two official certifications on MySQL fro Oracle. I can help you with any MySQL/MariaDB requirements you might have.

Hi, Hope you are doing well! I'm 5+ years experienced PHP, codeigniter, laravel and WordPress developer having worked on a variety of projects. Kindly share your requirements so that I can analyse it and we can work together on the requirements. Your response will be awaited. Thanks