php-gaming-website icon indicating copy to clipboard operation
php-gaming-website copied to clipboard

Published 20 hours ago • verified publisher icon marein

Use JSON partial updates

Open marein opened this issue 3 years ago • 1 comments

MySQL is used as a document store in the connect four context. Currently the aggregate column gets the whole serialized game when changes are made, see here. This can be improved by partially updating the JSON column which is available since MySQL version 8.0, see here.

marein avatar Apr 01 '22 22:04 marein

Tested this a few months ago. No notable difference in performance. Would only be interesting for replication or reducing network traffic at the moment. The added code complexity doesn't justify this, as neither of the two benefits are currently bottlenecks.

marein avatar Apr 11 '24 20:04 marein