Re: Suggest proper table design please

[Peter Brawley]

For your binary domains (acct_approved, validemail, usertype, userratng), TinyInt ("Bool", rilly pseudobool) would perform better than Enum.

After making those changes I'd run EXPLAIN EXTENDED on each slow query, with and without indexes on those columns. I think you will find those indexes won't help much with performance, either in the one table or farmed out to multiple tables.

If your queries use LIMIT, though, you may see performance gains from reworking the LIMIT clauses as WHERE arguments.

PB