> > We're using CDB (for maximum speed and huge username count). That's why SQL tricks are not an option :( > > > > So when you build the CDB file, why not lowercase (or UPPERCASE) the usernames > then? And how many is "huge username count"? We have some customers up around > the million mark running off SQL. You know, that is probably the best solution. I'll lowercase it when I add the entry to the CDB, and then just do the RewriteUsername tr/A-Z/a-z/ thing. That's the cleanest, simplest solution. As far as "huge", we're trying to design the system for future, anticipated capacity of around 1M. I'm glad some folks can do that capacity with SQL; that just means our CDB is going to be that much faster! :) Thanks Hugh, and everyone else, for the tips! Dave === Archive at http://www.starport.net/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
