[Asterisk-Users] Your thoughts..

[David C. Troy]

Do it with MySQL CDR and you should avoid all of those issues; just add a 
field to store the cost to the schema and compute it whenever makes sense.

Dave

=====================================================================
David C. Troy   [dave at toad.net]                   410-384-2500 Sales
ToadNet - Want to go fast?                        410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net

On Fri, 14 Nov 2003, WipeOut wrote:

> I need to get your thoughts on something.. :)
> 
> I am trying to create a system to process the CDR call logs for 
> department accounting..
> 
> I think there are two ways of doing it.. Either I can create an AGI that 
> will run on the "h" extension and will lookup the last entry that 
> matches the account code of the call that just ended in the MySQL CDR 
> and calculate the call cost immediately..
> Or
> I can use a cron job say every 5 mins to move the Master.csv file to a 
> temporary location and then process all the lines in the csv and put the 
> results into the DB and then delete the Master.csv from that temporary 
> location..
> 
> Which way will be better in terms of reliability and performance?
> 
> What will the issues be if the Master.csv is being updated at the exact 
> moment my cron job tries to move it? is there any file locking or a 
> method of delaying Asterisk's write or the cron's move operation till 
> the file is availible?
> 
> Thanks for you thoughts..
> 
> Later
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
>