Re: SMS Reports

[vinayak mv]

Please search mysql trigger or mysql indexing

On Tuesday 11 October 2016, Web Services  wrote:

> Hi Vinayak,
>
> thanks for your reply
>
> can you please explain little more about this ?
>
> Thanks
>
> On Tue, Oct 11, 2016 at 4:06 PM, vinayak mv  > wrote:
>
>> Better index the searching fields
>>
>>
>> On Tuesday 11 October 2016, Web Services > > 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.*"
>>
>>
>>
>>
>

-- 
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.*"

Re: SMS Reports

[Web Services]

Hi Vinayak,

thanks for your reply

can you please explain little more about this ?

Thanks

On Tue, Oct 11, 2016 at 4:06 PM, vinayak mv 
wrote:

> Better index the searching fields
>
>
> On Tuesday 11 October 2016, Web Services  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.*"
>
>
>
>

Re: SMS Reports

[vinayak mv]

Better index the searching fields

On Tuesday 11 October 2016, Web Services  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.*"