Hello I use two fields. for name and domain. So I can sort the domains. A other way is to replace the @ with a other character. [email protected] -> abc=def.ch
Regards, Oliver Am 28.03.2010 um 18:34 schrieb Steve Alex: > What is the best way to query an email address in 4D? I think the embedded @ > causes some performance problems on a straight query. > > I split the email address into name and domain and queried "name@", then > query selection for "@domain" and it does that in a few milliseconds compared > to a couple hundred milliseconds for a straight query. > > Just wondered what the preferred method was. > > Steve Alex > _______________________________________________ > Active4D-dev mailing list > [email protected] > http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev > Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/ _______________________________________________ Active4D-dev mailing list [email protected] http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
