We wrote a call screening (and CID rewrite) app for an ITSP a few years ago. We had to use MySQL as the astDB could not keep up (* was choking – we did dig deeper we just switched to MySQL). I don’t think astDB is the right way to go. If you’re comfortable writing a * func then you might as well go with MySQL.
From: [email protected] [mailto:[email protected]] On Behalf Of Gabriel Ortiz Lour Sent: Wednesday, March 22, 2017 9:51 AM To: Asterisk Users Mailing List - Non-Commercial Discussion <[email protected]> Subject: Re: [asterisk-users] Large astDB - millions of tuples - issues? Hi Dovid, I'm trying to get rid of my AGIs. I wrote an * func to check directly my PG database, and then I saw that * already has a func_blacklist that will check astDB. I was thinking the issues I might have using astDB for it. If I do some performance tests I get back here with the results. Thanks, Gabriel 2017-03-22 10:40 GMT-03:00 Dovid Bender <[email protected] <mailto:[email protected]> >: I have never tested something that large but I would think it would be slow. Why not use an age with reddis or mysql? On Mar 22, 2017 9:32 AM, "Gabriel Ortiz Lour" <[email protected] <mailto:[email protected]> > wrote: Hi all, Does anyone uses astDB for a large amount of data, in special for implementing black lists with millions of numbers (i'd like about 2 or 3 million)? That would be held in memory right? Is this (memory consumption) the only problem I could face? Att. Gabriel -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
