On Mon, Nov 17, 2008 at 7:17 AM, fastest963 <[EMAIL PROTECTED]> wrote:
> > > Another note: md5 is case-sensitive! If using indexes as I have stated > above and using tables with md5 first letter, then remember to do > strtolower() for indexes and before doing md5! > Great optimizations, I especially like the sharding/partitioning. As a Unicode geek I feel compelled to mention: I'm not sure PHP strtolower is safe for multi-byte UTF-8. I'm quite sure it's not safe in Ruby (you have to use string.chars.downcase). My PHP is very rusty but I think the (slower) mb_strtolower is multi-byte character safe. I don't think this affects the code you're using, but it's always worth mentioning. — Matt
