AlexT
Well-known member
Split from here.
In the database, you could store users's email domain names separately from the email address and refer to them by index. This could potentially save a lot of disk space (since we're talking about avoiding overhead) for forums with a larger user base, given that the majority of users use one of the few available public email providers. See here for an example:
http://www.mssqltips.com/sqlservertip/2657/storing-email-addresses-more-efficiently-in-sql-server/
In the database, you could store users's email domain names separately from the email address and refer to them by index. This could potentially save a lot of disk space (since we're talking about avoiding overhead) for forums with a larger user base, given that the majority of users use one of the few available public email providers. See here for an example:
http://www.mssqltips.com/sqlservertip/2657/storing-email-addresses-more-efficiently-in-sql-server/
Upvote
2