On Sun, Aug 1, 2010 at 6:24 PM, Aryeh Gregor Simetrical+wikilist@gmail.com wrote:
That won't work, because it won't count users whose settings are all default. However, we can tell who's switched because user_options will be empty.
SELECT COUNT(*) FROM user WHERE user_options = ''; SELECT COUNT(*) FROM user; +----------+ | COUNT(*) | +----------+ | 3491404 | +----------+ 1 row in set (10 min 20.11 sec)
+----------+ | COUNT(*) | +----------+ | 12822573 | +----------+ 1 row in set (7 min 47.87 sec)
I.e., only about a quarter of users have been ported to user_properties. Why wasn't a conversion script run here?