On Sun, Aug 1, 2010 at 6:24 PM, Aryeh Gregor
<Simetrical+wikilist(a)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?