My setup : Trixbox 2.6.1 & TE410P running well .: 1. I need to store the CallerId of the PSTN caller with his language preference so that next time he is played the prompt in his language that he chose the first time.What would be better - storing his number in the Asterisk DB and using Dbput and DBget ? or storing it in MySQL from the dial plan and quering it everytime to see the callers record ? how many records can AstDB handle safely ? In my case the total records wont exceed 20,000 since there are many repeat callers ? rgds Sriram -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090421/a750a86e/attachment.htm
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sriram wrote:> > 1. I need to store the CallerId of the PSTN caller with his language > preference so that next time he is played the prompt in his language > that he chose the first time.What would be better - storing his number > in the Asterisk DB and using Dbput and DBget ? or storing it in MySQL > from the dial plan and quering it everytime to see the callers record ? > how many records can AstDB handle safely ? In my case the total records > wont exceed 20,000 since there are many repeat callers ?20K records? While I'm not sure exactly how many records AstDB could handle it would seem to me that 20K would be a high number. My inclination would be to use a full database... perhaps you'd like to store more about that callerID than just the caller's preferred language. Using a real DB would certainly make that easier. Barry -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFJ7bRRCFu3bIiwtTARAqTvAJ4jS0/kZeHo33+w9gjZ88dYB3SeDACgg2+t LhVIBsPzxyQ/g542/NjMo8U=d+JZ -----END PGP SIGNATURE-----
i'd use mysql... and i do use mysql for this... 2009/4/21 Sriram <d_r_sriram at hotmail.com>> My setup : Trixbox 2.6.1 & TE410P running well .: > > 1. I need to store the CallerId of the PSTN caller with his language > preference so that next time he is played the prompt in his language that he > chose the first time.What would be better - storing his number in the > Asterisk DB and using Dbput and DBget ? or storing it in MySQL from the dial > plan and quering it everytime to see the callers record ? how many records > can AstDB handle safely ? In my case the total records wont exceed 20,000 > since there are many repeat callers ? > > rgds > Sriram > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090421/7f5a46cf/attachment.htm
"Sriram" <d_r_sriram at hotmail.com> writes:> 1. I need to store the CallerId of the PSTN caller with his language > preference so that next time he is played the prompt in his language that > he chose the first time.What would be better - storing his number in the > Asterisk DB and using Dbput and DBget ? or storing it in MySQL from the > dial plan and quering it everytime to see the callers record ? how many > records can AstDB handle safely ? In my case the total records wont exceed > 20,000 since there are many repeat callers ?Asterisk DB is either an SQLite database or a Berkeley database, I forget which (did it change?). Either way, 20,000 should be a problem for the underlying database. I'd still go for the "real" database (using Postgres, but I guess you can use MySQL if you feel like it), probably using func_ODBC. With Asterisk DB you have to go through Asterisk to view or change contents of the database; a real database makes management easier. /Benny
Benny Amorsen wrote:> Asterisk DB is either an SQLite database or a Berkeley database, I >The last I knew, it was BerkeleyDB. Doug -- Ben Franklin quote: "Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety."