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

SMS Reports

[Web Services]

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