Fermé

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!

Compétences : PHP, MySQL, node.js, Python, NoSQL

en voir plus : 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

Concernant l'employeur :
( 30 commentaires ) mackay, Serbia

Nº du projet : #21891907

37 freelance font une offre moyenne de $128 pour ce travail

sapotacorp

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(817 Commentaires)
8.7
usuf001

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(569 Commentaires)
7.3
luiswilliam

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(68 Commentaires)
7.1
C3guru

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(45 Commentaires)
7.1
JinDongZhe

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(78 Commentaires)
7.3
appbank888

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(32 Commentaires)
6.7
pablotorres

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(150 Commentaires)
6.0
vladzolotukhin

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(39 Commentaires)
5.7
whiteeagle0001

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(27 Commentaires)
5.7
seniorcoder024

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(19 Commentaires)
5.0
JBJeanniton

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(12 Commentaires)
5.1
imranulhasn

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(38 Commentaires)
5.2
lesteraguilar

Fingers crossed for your job.. I am sure of Angular.js, React.js, Vue.js, PHP, Laravel, node.js, Python, Django, MySQL, MongoDB, PostgreSQL, Docker, Javascript, Java, CSS, Bootstrap, HTML. Kindly do me a favor by hirin Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(19 Commentaires)
5.2
WebKing2019

⭐⭐⭐Dear sir, the client is always all right. ⭐⭐⭐. ~~I can finish your Node JS project for a short time, perfectly. ~~ I am very happy to get this opportunity to bid for your project. I have just read your requirements Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(10 Commentaires)
4.8
rk123c

Hey Hi, I've got your issue, I can fix that issue in php or I can suggest you other languages like python or java. I need to look into your code and find exact issue. If it's performance related, we can find alterna Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(11 Commentaires)
4.3
WebExpertNatasha

Your requirements can be performed by pagination. You should not fetch data at once. But you can fetch data by offset and limit. In order to do this, client program should be modified accordingly. Thanks and I am look Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(14 Commentaires)
4.1
mayankupadhyay

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(31 Commentaires)
4.3
GlobalSolution3

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(11 Commentaires)
3.9
popov4sa

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)
3.7
BestPrince1120

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
3.7