[asterisk-users] Large astDB - millions of tuples - issues?

[Telium Technical Support]

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-bounces at lists.digium.com [mailto:asterisk-users-bounces at 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 at 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 <dovid at telecurve.com <mailto: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 <mailto: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/1ff6d43a/attachment.html>