Re: mysql domain lookups

• Previous message: Wietse Venema: "Re: HOLD messages CC/BCCd to more than 10 recipients?"
• Maybe in reply to: Dick Middleton: "mysql domain lookups"
• Next in thread: (no name): "Re: mysql domain lookups"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Dave McGuire wrote:

>> Luckily mysql seems to be able to do the job but I hate to think how
>> many cpu cycles it uses.
>>
>> query = SELECT helo FROM country WHERE '%s' RLIKE CONCAT('\\.', code,'$')
>>
>> :-)
>
> Ouch! I hope you have query caching enabled on your database server. ;)

It did work but I've reverted back to hash tables of course.

Dick

• Previous message: Wietse Venema: "Re: HOLD messages CC/BCCd to more than 10 recipients?"
• Maybe in reply to: Dick Middleton: "mysql domain lookups"
• Next in thread: (no name): "Re: mysql domain lookups"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]