Please search mysql trigger or mysql indexing
On Tuesday 11 October 2016, Web Services <coinhost...@gmail.com> 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 <vinayakvasu...@gmail.com
> <javascript:_e(%7B%7D,'cvml','vinayakvasu...@gmail.com');>> wrote:
>
>> Better index the searching fields
>>
>>
>> On Tuesday 11 October 2016, Web Services <coinhost...@gmail.com
>> <javascript:_e(%7B%7D,'cvml','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.*"
>>
>>
>>
>>
>
--
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.*"
