Re: [PATCH] include destination into dlr lookup

Hi Alexander,

On Sat, 2004-09-25 at 21:28 +0200, Alexander Malysh wrote:
>  * It's not possible to use the whole destination in sql query, so we just
>  * strip country prefix and do DB lookup like 'like "%striped-dst"' and so
>  * increase probability to find a right DB entry.

This approach seems to be a wee lot slower than direct lookup.

I believe avoiding use of `like` in SQL statements is better.

Haven't looked at the patch yet, but let me ask, how do you strip
country info? USA is +1 AFAIK, so how would a number like this:

	+1 123 1234567

stripped? How reliable is the result?

A few years ago, I heard that Hong Kong switched to 8-digit phone
numbers. What do you think about this? :)
-- 
Enver ALTIN                   |        http://skyblue.gen.tr/
Software developer @ Parkyeri |      http://www.parkyeri.com/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)

iD8DBQBBVs4lZCB2FZvqK0sRAjPtAJ0UGPABwFZX06B6uYrloO3weh6TSQCeKMdB
A+rZx+gHz8UeLzTBUUIzwMc=
=rzfO
-----END PGP SIGNATURE-----