Tuesday, January 8, 2013

Project MC on 1/8

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