In Progress

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.

Sincerely,

THE M-GROUP

Skills: AJAX, Javascript, MySQL, PHP, Software Architecture

See more: message queue server, last update freelancer, freelancer uses, freelancer stack, freelancer last update, freelancer gb, freelancer explained, freelancer bulk sms, database queue, message queue, m group, trace stack, javascript repair, daemon scripts, using scripts, using sms, php execute rows, stack developer, reduce database size, script receive messages, sms reply, database historical, bulk database provider, group scripts, receive sms different number

About the Employer:
( 114 reviews ) Miami, Kenya

Project ID: #2519609

Awarded to:

tvoodoo

Please check the PMB when you find the time.

$150 USD in 0 days
(86 Reviews)
5.6

9 freelancers are bidding on average $194 for this job

gslogics123

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

$200 USD in 2 days
(218 Reviews)
7.3
scriptphp87

Hello Please read more than private message thank you

$150 USD in 3 days
(103 Reviews)
6.7
k1ng440

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

$250 USD in 3 days
(95 Reviews)
6.5
sateeshranga

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

$200 USD in 1 day
(2 Reviews)
3.2
deba360

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

$150 USD in 3 days
(2 Reviews)
2.9
eblive

Hi, I can help you out with this.

$150 USD in 20 days
(2 Reviews)
2.0
PHPspecialist8

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

$200 USD in 0 days
(0 Reviews)
0.0
triptych717

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 More

$200 USD in 5 days
(0 Reviews)
0.0
smsforrent

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 in 2 days
(0 Reviews)
0.0