[EMAIL PROTECTED] wrote: > Yes, the xml files give you tons of info... but isn't it a little > insufficient - performance wise - > to open and close so many files in such a little time. In a PBX > environment that wouldn't be an > issue but if we get to the small-voip-carrier level (some thousand cdrs > per hour) > that could slow things down considerably, wouldn't it? > Not that you'd notice. We run XML CDR to database scripting on each box that we use for switching, and it's a pretty trivial task compared with switching all that media. Doing it this way is:- (a) distributed - one process per box scales nicely; (b) robust - script down, DB down, no problem: files just queue up; (c) simple - the script logic is trivial: - while 1 - for each file in the XML CDR directory - open it - parse it (XML::Simple for us) - insert it in to the DB - delete it - sleep for a couple of seconds Two error cases: can't parse or can't find data which should be there: move the file in to another directory to be examined by real eyes; DB insert fails: break out of inner loop and it'll be retried after a short pause.
--Dave -- David Knell, Director, 3C Limited T: 020 8114 8901 F: 020 3002 7257 M: 001 415 630 3031 http://www.3c.co.uk _______________________________________________ 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