Project MC: I've generated a test-case in which the user table contains 1,250,000 accounts. The
counter calculation can be accomplished through a single SQL statement. Currently that calculation takes roughly half a second. This is too long. The calculation will need to be cached in order to scale appropriately. I've attempted various short-cut methods for this calculation--there may be more to try--but MySQL seems to be the fastest when left to it's own devices. I need to test InnoDB and confirm that running this calculation will not lock the users table.
No comments:
Post a Comment