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.
Bu iş için 37 freelancer ortalamada $128 teklif veriyor
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], gnetentertainment.com. Thanks, Michael
Hi there, I have simple solution for the issue. please send a private message to discuss more. thank you so much. syed
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 Daha Fazla
Hello, I have checked. I will finish it in a few hours. Please feel free to contact me at anytime. thank you for your viewing my proposal. Kim
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.
Hi,client. I checked your PHP code and the description. Your time out error is concerned with the PHP init setting. You can process muti thread at the same time. I will deliver this successfully as you want. Your php c Daha Fazla
Greetings!! I have read your requirements carefully and i found my self fit in order to complete this project I Have vast experience in development and i have also made same kind of web and mobile application on same Daha Fazla