OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: mysql domain lookups

From: Dick Middleton (dickfouter.net)
Date: Mon Sep 03 2007 - 13:01:02 CDT

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