gt; >> locking?). Can you batch up several numbers in one command, saving on
> the
> >> per-command overhead?
> >>
> >>
> >>
> >> Also consider it in light of the rest of your application. If everything
> >> is in the same databas
rformed well
>> under 100 calls/sec – not usable. After a few days of playing with things,
>> it went over 1000 calls/sec, which is comfortable enough for a $500 server.
>> This is matching 100 gateways and dialplans with several thousand entries
>> per dialplan, across 4 mi
for a $500 server. This is
> matching 100 gateways and dialplans with several thousand entries per
> dialplan, across 4 million+ routes, doing QBR/LCR in the process.
>
>
>
> -Michael
>
>
>
>
>
> *From:* freeswitch-users-boun...@lists.freeswitch.org [mailto:
> frees
-boun...@lists.freeswitch.org
[mailto:freeswitch-users-boun...@lists.freeswitch.org] On Behalf Of Muhammad
Shahzad
Sent: Wednesday, October 14, 2009 1:55 AM
To: freeswitch-users@lists.freeswitch.org
Subject: Re: [Freeswitch-users] Some help with my post-paid billing project
I fully agree that
DB[:rates].where(:prefix => substring('number', 1, length(prefix)).first
Rather.
On Wed, Oct 14, 2009 at 8:28 AM, Diego Viola wrote:
> Nice, I just converted this to Ruby/Sequel.
>
> DB[:rates].first{{prefix=>substring('number', 1, length(prefix))}}
>
> Thanks for the help :).
>
>
> On Wed, Oct
Nice, I just converted this to Ruby/Sequel.
DB[:rates].first{{prefix=>substring('number', 1, length(prefix))}}
Thanks for the help :).
On Wed, Oct 14, 2009 at 2:07 AM, TTNC - Adnan Barakat
wrote:
> Diego Viola wrote:
> > I'm using MySQL now but I will try PostgreSQL with the prefix module, is
>
> -Michael
>
>
>
> *From:* freeswitch-users-boun...@lists.freeswitch.org [mailto:
> freeswitch-users-boun...@lists.freeswitch.org] *On Behalf Of *Diego Viola
> *Sent:* Tuesday, October 13, 2009 7:54 PM
> *To:* freeswitch-users@lists.freeswitch.org
> *Subject:* Re: [Freeswitch-users] S
t the PK always.)
-Michael
From: freeswitch-users-boun...@lists.freeswitch.org
[mailto:freeswitch-users-boun...@lists.freeswitch.org] On Behalf Of Diego Viola
Sent: Tuesday, October 13, 2009 7:54 PM
To: freeswitch-users@lists.freeswitch.org
Subject: Re: [Freeswitch-users] Some help with my post
Diego:
Didn't wrote a prepaid system already? how did you compare the prefix in
that system then?
On Wed, Oct 14, 2009 at 10:07 AM, TTNC - Adnan Barakat wrote:
> Diego Viola wrote:
> > I'm using MySQL now but I will try PostgreSQL with the prefix module, is
> > there a way to do that without the
Diego Viola wrote:
> I'm using MySQL now but I will try PostgreSQL with the prefix module, is
> there a way to do that without the prefix module and with regular SQL?
>
> Any examples?
SELECT * FROM rates WHERE prefix = SUBSTRING('$NUMBER$', 1,
LENGTH(prefix)) LIMIT 1
Adnan
> Diego
>
> On Tue,
Wrong question.
Is there a way to compare numbers with prefixes without using the prefix
module?
Diego
On Wed, Oct 14, 2009 at 1:36 AM, Diego Viola wrote:
> I'm using MySQL now but I will try PostgreSQL with the prefix module, is
> there a way to do that without the prefix module and with regu
I'm using MySQL now but I will try PostgreSQL with the prefix module, is
there a way to do that without the prefix module and with regular SQL?
Any examples?
Diego
On Tue, Oct 13, 2009 at 10:45 PM, Even André Fiskvik wrote:
> What database are you using?
> You could do this with regular SQL, b
Why not use mod_lcr to determine your rates? It already does all this
work for you. I even added a feature recently that allows one to
calculate/lookup end user rates (in addition to the carrier rate you
are paying for a given route).
On Tue, Oct 13, 2009 at 4:53 PM, Diego Viola wrote:
> Hello,
What database are you using?
You could do this with regular SQL, but it would by a costly operation,
for PostgreSQL we're using the prefix module:
http://pgfoundry.org/projects/prefix/
You can then match the closest prefix by using something like
"WHERE myprefix_col @> caller_destination_number O
Should I try to pass the whole DNIS and compare with teh rates list/table
and when a prefix from the DNIS matches with the rates list I get hte rate
that way?
On Tue, Oct 13, 2009 at 9:53 PM, Diego Viola wrote:
> Hello,
>
> I'm trying to write a post-paid billing script, I have the CDR on my
>
Hello,
I'm trying to write a post-paid billing script, I have the CDR on my
database and also a "rates" table, the CDR contains fields like
caller_destination_number, variable_duration, etc. and the rates table
contains: destination, prefix, rate (cost).
The problem is that I can't just strip the
16 matches
Mail list logo
