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
