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: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Gabriel Ortiz Lour Sent: Wednesday, March 22, 2017 9:51 AM To: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com> 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 <do...@telecurve.com <mailto:do...@telecurve.com> >: 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" <ortiz.ad...@gmail.com <mailto:ortiz.ad...@gmail.com> > 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