Better index the searching fields
On Tuesday 11 October 2016, Web Services <coinhost...@gmail.com> wrote:
> Dear All,
>
> i want to discus an little issue which i face with my sms
> server/application
>
> am using kannel 1.4.4 along with sqlbox and also i have develop full php
> script for sending sms and check reports
>
> all things works fine but i have little issue with reports sync
>
> all reports comes from operator/smpp directly insert to my sql-box table
> sent_sms and another my php script sync this reports to my reporting
> database.
>
> but my php script take very long time to update my reports to my reporting
> DB
>
> now my question is : how i can improve speed of my php script for sync DB
> one solution which i have is upgrade server configuration any alternate
> solution is valuable.
>
> please suggest if you have any alternate solution
>
> Thanks
>
> Deepak
>
--
Thanks & Regards,
Vinayak
======================================================================
*Confucius* once said,
"*Life is really simple, but we insist on making it complicated.*"
*Leonardo da Vinci* once said,
"*Simplicity is the ultimate sophistication.*"
*Albert Einstein* once said,
"*Everything should be made as simple as possible, but not simpler.*"
