Repair 2 SMS Scripts

Dear Freelancer(s),

We need help repairing two SMS scripts. The problem with each script is explained below:

Problem 1:

We have a script that uses the “GET” method and allows us to receive and reply to SMS messages. We have noticed in the last few weeks that if an SMS message arrives and we do not respond to it in 4-5 minutes it disappears completely without any trace. We are therefore loosing or unable to reply to dozens of SMS daily. We urgently need this problem fixed.


Problem 2:

We have a script that sends bulk SMS. The script is feed by a large database of 2.5 GB. The size of the database is causing the script to execute very slowly. Our Hosting provider has suggested a number of solutions as indicated below.

(Suggestions from Host)

The simple answer is that you need to either reduce the size of your database or you would need to move your database to a different server. The best option I see would be to truncate the queue table periodically. It is currently over 62 million rows in size. If you need to maintain the information for historical purposes, you can always dump the table into a file or another database, and then truncate the table. With a smaller table, the update queries should run much faster and the scripts will execute more quickly. This will prevent them from stacking. In the long term, you may want to look into having your developer write your SMS delivery script to run as a single daemon, so that way dozens and dozens of instances of a single script that stack up. This would reduce the memory usage from your deliveries, keeping the server more stable and shouldn't sacrifice performance.

(Preferred Solution for Problem 2)

We want to fix problem 2 using the most reliable method. We do not want to reduce the size of our database, however we understand that the large size is what is causing the problem. Kindly come up with the best solution to fix this problem.



Taidot: AJAX, Javascript, MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: the freelancer stack, message queue server, last update for freelancer, freelancer uses, freelancer stack, freelancer server update, freelancer last update, freelancer gb, freelancer explained, freelancer bulk sms, freelancer 2 2, database queue, best way to get freelancer developer, what is a stack, freelancer update 1.2, message queue, m group, trace stack, javascript repair, daemon scripts

Tietoa työnantajasta:
( 114 arvostelua ) Miami, Kenya

Projektin tunnus: #2519609

Myönnetty käyttäjälle:


Please check the PMB when you find the time.

$150 USD 0 päivässä
(86 Arvostelua)

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello sir/mam Please check the message box for solution. Regards Ashwin

$200 USD 2 päivässä
(218 arvostelua)

Hello Please read more than private message thank you

$150 USD 3 päivässä
(103 arvostelua)

Full time freelance web developer with over 8 years of commercial experience.

$250 USD 3 päivässä
(95 arvostelua)

Hi, I ready to check the issues now. Can you check in PMB. Thanks Mukta

$200 USD 1 päivässä
(2 arvostelua)

Hi, I have relevant experience. Please check PMB for details.

$150 USD 3 päivässä
(2 arvostelua)

Hi, I can help you out with this.

$150 USD 20 päivässä
(2 arvostelua)

Good day - Expert in PHP,MYSQL,AJAX. Dedicate to provide you best quality services. Please check detailed message !!!!!

$200 USD 0 päivässä
(0 arvostelua)

If I'm understanding correctly.. (Problem 1) You receive SMS via the script, but it only stores them for 4-5 minutes? I'd either store them flat-file JSON or via DB. (Problem 2) It could be the size, it coul Lisää

$200 USD 5 päivässä
(0 arvostelua)

Hi, i have seen the details of the project. i can make as you need . please see the Private message for more details . THANKS

$250 USD 2 päivässä
(0 arvostelua)