[Asterisk-Users] CDR Output

[Matteo Brancaleoni]

I agree. postgres could be too slow if used into a big
system and you can't afford a rather good machine.

mysql is very fast and simple.

and I don't see where's the problem into the extraction...
a simple division could be done in any language, with any
program... 

matteo.

Il mar, 2003-03-04 alle 20:27, asterisk at billheckel.com ha scritto:
> Why would anyone use such a big axe for a small problem, a trigger to do simple math. Bah.
> 
> MySql is perfectly suitable for CDR logging on any practical phone system short of telco main office 
> eqpt.
> 
> 
> Karl Putland wrote:
> > On Tue, 2003-03-04 at 11:57, Matthew S. Hill wrote:
> > 
> >>I am pushing all the cdr info to a MySQL database on a separate machine. 
> >>I have noticed that the duration times for all calls are recorded in 
> >>seconds, by Asterisk. Is there a way to set the recorded call duration 
> >>to a decimal representation of minutes? ie 90 sec = 1.5 min. My 
> >>extraction process would be a little simpler if the data dumped into the 
> >>database were minutes and not seconds.
> >>
> > 
> > 
> > Write a trigger for on insert or a view that converts sec->min.  Oh wait
> > your using MySQL.  Use PostgreSQL ;)
> > 
> > 
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
-- 
Matteo Brancaleoni <mbrancaleoni at espia.it>
Espia - Emmegi Srl