Re: [PATCH] include destination into dlr lookup

Alexander Malysh <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
Hi,

sorry for delay...

Enver ALTIN wrote:

> Hi,
> 
> On Sun, 2004-09-26 at 17:07 +0200, Alexander Malysh wrote:
>> > I believe avoiding use of `like` in SQL statements is better.
>> 
>> it's impossible to avoid `like` by indirect lookup... if it's
>> possible, please teach me ;)
> 
> Walking upstairs from subway this morning, I remembered this and thought
> that storing everything stripped and making strict comparison with
> stripped data would work.
> 
> So we would INSERT a DLR record with stripped destination and
> UPDATE/DELETE/SELECT would get a stripped destination for WHERE clause.
> 
> What do you think?

I don't like the idea of bloating the db and we will not win too much
performance (IMHO)... (we should really make benchmarks with
direct/indirect db lookup)

-- 
Thanks,
Alex
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.