Fix php mysql big table problem (or migrate to other language or NoSql)

I have a table with 3 columns but with more than 17,000,000 rows at this moment, I will add more.

I attached here the php that do the queries to this table. This php is requested by my desktop app. the problem is that the app work with multithreads, so the php do many request at the same time ,so the server show me timed out error and some requests dont get the right answer from server.

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.

I accept recommendation to migrate it to other programming language or other db like NoSql.

I'm using CentOS Linux.

Please before send me your proposal check the attached php for understand how it work. the php is simple and commented.

thanks you!

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

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:
( 37 reviews ) mackay, Serbia

Project ID: #21891907

23 freelancers are bidding on average $120 for this job


Hello sir, I am available here to discuss more with this project. We have finished 14 node.js projects. Example: [login to view URL], [login to view URL], Thanks, Michael

$113 USD in 1 day
(876 Reviews)

Hi there, I have simple solution for the issue. please send a private message to discuss more. thank you so much. syed

$83 USD in 1 day
(600 Reviews)

Hi, Frankie S.! I read the description of your project thoroughly. I understand your requirements initially and I have experiences of the field. I am a specialist of: * React.js, Angular for Front-end, * .NET Core A More

$140 USD in 2 days
(72 Reviews)

Greetings. I checked the php script you attached and read your job post carefully. I can surely fix your timeout issue and suggest more efficient way. Do you know mysql indexing? Anyway, pls contact me. I can start you More

$140 USD in 1 day
(45 Reviews)

Dear Manager. How do you do? i read your project carefully. I`m interested to work with you!! I have rich experience in web development and mobile . I think your project is adaptable for me. Looking forward to More

$155 USD in 3 days
(80 Reviews)

Hi I am “Imranul” free here for your project and can start immediately. I read your ☑️ Fix php mysql big table problem (or migrate to other language or NoSql) Project description and I am confident that no one can do More

$140 USD in 7 days
(65 Reviews)

Friend, I think you should to normalize the table, making more tables, and split the information, send me a data sample, we could find a way to reduce the number of rows.

$140 USD in 7 days
(150 Reviews)

Hello, sir! I have read your job description carefully. I am a senior full stack developer who has rich experiences in ecommerce website development. I have been working for 6 years in information technology. I have g More

$140 USD in 3 days
(33 Reviews)

Hello, I am a very professional full-time freelancer. Working with passion and dedication. I have 5+ years of website development experience in PHP using Laravel, Codeigniter, Wordpress, Yii, MySQL, Bootstrap, HTML5, More

$140 USD in 7 days
(1 Review)

Hello, How are you? I have read your description in more detail and have much interest in your project. So I think that I can finish your work perfectly as you need.I have many experiences for PHP, MySQL. If you need More

$140 USD in 7 days
(27 Reviews)

Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1* I can do Data RESEARCH from any platform for certain subjects More

$30 USD in 1 day
(17 Reviews)

Hi, I am very interested in your project. Let me introduce myself quickly: I am a Senior Programmer Analyst with over 15 years of experience. I worked on large projects for governments (Togo, Jamaica, Haiti ...) and fo More

$120 USD in 2 days
(12 Reviews)

Interested, having exp over 7 year in domain , I Have simple solution for the [login to view URL] me for more detail

$80 USD in 7 days
(49 Reviews)

Hello, I have 10 years of experience in PHP, Wordpress, Codeigniter, Laravel, Python, Django, JavaScript, Shopify, Magento, OpenCart, Angular.JS, HTML, CSS. Please have a glance here on my previous work. [login to view URL] More

$140 USD in 7 days
(13 Reviews)

I have rich experiences in jquery big data table in client side and server side so it is fetching data for every page thanks.

$140 USD in 7 days
(12 Reviews)

Hello, Client. I'm web developer named Anton. I have read and understood your requirements. I am pleased to bid your task. Because It is a skill I am good at. If you want, I will help you. Hoping for the good news... More

$40 USD in 1 day
(10 Reviews)

hello ! I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. Awaiting an affirmative response from More

$140 USD in 2 days
(3 Reviews)

Hello there, I checked the attached php file for your job. It just grab the database rows upto 250 which makes your task slow and break in the middle out of the enough RAM for apache. Let's do it with an AJAX request. More

$175 USD in 1 day
(6 Reviews)

Dear Hiring Manager, I am Redhat Certified Engineer. I have 8 years of experience as a Linux System Administrator. I posses good knowledge of mail server like zimbra, sendmail, web server like Apache, shell scripting, More

$140 USD in 7 days
(18 Reviews)

*****_ Hello, Frankiepenta _***** How are you ? I have read your detail very carefully and understood what you want. I have developed a lot of project like your project. And i am very familiar with your project. So i h More

$110 USD in 2 days
(7 Reviews)