Gabriel Ortiz Lour
2017-Mar-22 13:32 UTC
[asterisk-users] Large astDB - millions of tuples - issues?
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20170322/259aeefa/attachment.html>
Dovid Bender
2017-Mar-22 13:40 UTC
[asterisk-users] Large astDB - millions of tuples - issues?
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.admin at 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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20170322/a1446cf2/attachment.html>
Gabriel Ortiz Lour
2017-Mar-22 13:50 UTC
[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 <dovid at 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.admin at 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 >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20170322/2a88c212/attachment.html>