Dear All, I have 200k cdr record daily. what's good solution to record and report ? Now I'm thinking about CDRTOOL from ag project and areski stat (now part of a2billing). My idea use mod_xml_cdr -> http (may be php, or perlembded on nginx) -> mysql i want to report ASR, ACD , any comment ? Dome C.
Look at default config for mod_cdr_csv, sql template. It can produce a sequence of SQL INSERT statements which can be later fed (after daily log rotation) to mysql client program. I see no reason to employ xml for this task, the language hard to read and parse for both human and computer. On Tuesday 12 January 2010, Dome Charoenyost wrote:
Dear All, I have 200k cdr record daily. what's good solution to record and report ? Now I'm thinking about CDRTOOL from ag project and areski stat (now part of a2billing). My idea use mod_xml_cdr -> http (may be php, or perlembded on nginx) -> mysql
i want to report ASR, ACD , any comment ?
Dome C.
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Also, you can have a cron job collect these more frequently than once per day. There are folks out there we grab them several times per minute and process them so that it is almost real-time. Of course, using mod_xml_cdr requires more effort up front but it *IS* real-time and more scalable. -MC On Tue, Jan 12, 2010 at 3:39 AM, Sergey Okhapkin <sos@sokhapkin.dyndns.org>wrote:
Look at default config for mod_cdr_csv, sql template. It can produce a sequence of SQL INSERT statements which can be later fed (after daily log rotation) to mysql client program.
I see no reason to employ xml for this task, the language hard to read and parse for both human and computer.
participants (3)
-
Dome Charoenyost
-
Michael Collins
-
Sergey Okhapkin