Re: [SR-Users] Changing acc_cdrs time and duration columns from varchar to int/float

2015-07-27 Thread mayamatakeshi
Hello Daniel, I am load testing it and after tens of millions of records, there were no issues. So I will push this to production. Thank you, Regards, Takeshi On Mon, Jul 27, 2015 at 4:41 PM, Daniel-Constantin Mierla wrote: > Hello, > > iirc, Kamailio does only insert operations, therefore if

Re: [SR-Users] Changing acc_cdrs time and duration columns from varchar to int/float

2015-07-27 Thread Daniel-Constantin Mierla
Hello, iirc, Kamailio does only insert operations, therefore if you tested and works, then should be no problem, because there is no select to retrieve the values back in kamailio. Cheers, Daniel On 21/07/15 00:07, mayamatakeshi wrote: > > > On Tue, Jul 21, 2015 at 6:35 AM, mayamatakeshi > mailt

Re: [SR-Users] Changing acc_cdrs time and duration columns from varchar to int/float

2015-07-20 Thread mayamatakeshi
On Tue, Jul 21, 2015 at 6:35 AM, mayamatakeshi wrote: > Hello, > I am planning to enable acc cdr in my kamailio 4.1 server. > I am testing in my lab and it is working fine. > However, when I check the table definition I see this: > > mysql> describe acc_cdrs; > ++--+--

[SR-Users] Changing acc_cdrs time and duration columns from varchar to int/float

2015-07-20 Thread mayamatakeshi
Hello, I am planning to enable acc cdr in my kamailio 4.1 server. I am testing in my lab and it is working fine. However, when I check the table definition I see this: mysql> describe acc_cdrs; ++--+--+-+-++ | Field | Type