Fix php mysql big table problem.

I have a table with 3 columns but with more than 17,000,000 rows.

I attached here the php that do the queries to this table. This php is request / running by my desktop app. the problem is that the app work with multithreads, so the php get many request at the same time ,so the server show me timed out error.

I need find a method to do my php code more efficient to can handle many request at the same time and do queries to big table.

ps: I accept recommendation to migrate it to other programming language or other db system.

thanks you!

Skills: PHP, MySQL, NoSQL, Python, node.js

See more: php mysql windows 2003 problem, php mysql query table, format php mysql display table, php mysql display table css, php mysql html table display, php mysql html table empty fields, php mysql loop table rows columns, php mysql overwrite table, php mysql sort table header, php mysql entry table, php mysql slow connection problem, php mysql show table drop, php mysql show table page, php mysql update table structure, php mysql sort table click header

About the Employer:
( 30 reviews ) mackay, Serbia

Project ID: #21815301

25 freelancers are bidding on average $38 for this job


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

$55 USD in 2 days
(97 Reviews)

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

$50 USD in 7 days
(65 Reviews)

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

$50 USD in 7 days
(39 Reviews)

Hi,client. I will fix soon. I have good experience in managing the mass tables in php and mysql. let's meet. thanks.

$50 USD in 1 day
(38 Reviews)

Hello! High Quality & Fast Delivery is promised. I fully got your point and I am so interested in your job. Your specification seems to be written for me. As a web expert, I am very confident with my skills and I have More

$20 USD in 1 day
(34 Reviews)

Dear client. I have read your all descriptions carefully and I am sure that I can complete your project in time and at high quality. As a full-stack developer, I have recommended skills in Front-end and Back-end develo More

$20 USD in 7 days
(19 Reviews)

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

$24 USD in 1 day
(96 Reviews)

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 w More

$10 USD in 1 day
(11 Reviews)

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 More

$24 USD in 1 day
(22 Reviews)

Hello, Client. Nice to meet you. I saw your job description carefully and understood what you want I am so interested in your project and want to work with you, I am senior web developer with rich experience of PHP an More

$21 USD in 1 day
(36 Reviews)

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

$10 USD in 1 day
(18 Reviews)

I am expert in Web designing/developing.I believe that I can be the best productive candidate for this requirement. My skills include : * PHP, CMS, WordPress, Laravel, Codeigniter, yii, Magento, Joomla, Ecommerce, HTM More

$20 USD in 7 days
(6 Reviews)

I am a Php developer.I also expert in wordpress.I have been worked during 7 yrs in Jquery/Javascript and core php also.I have been worked on that field during 7 years of experience with that filed. I am able to fix More

$80 USD in 2 days
(4 Reviews)

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 hel More

$30 USD in 1 day
(9 Reviews)

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 ha More

$35 USD in 1 day
(3 Reviews)

Hello! My master`s name is “trust”! Faithing my master, getting all-in. Let me go on, you can get the best project that you can ever get. Major Skills: “time, quality” Other Skills: : PHP, Python I am always ready to a More

$25 USD in 1 day
(7 Reviews)

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 More

$20 USD in 1 day
(3 Reviews)

Hi, Nice to meet you! I check your [login to view URL] file. I am very interesting your project and I am confident of I can help your job. I am confident of this project as I'm a professional expert with over 7 years of experi More

$20 USD in 7 days
(6 Reviews)

Hi, i modified the file, please check it [login to view URL] Thank you .............

$20 USD in 1 day
(5 Reviews)

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 priorit More

$50 USD in 7 days
(1 Review)