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, [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users -- Matteo Brancaleoni <[EMAIL PROTECTED]> Espia - Emmegi Srl _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users