On Tue, Jun 05, 2007 at 01:46:42PM +0800, Erick Papadakis wrote:
>
>GAME_COUNTS Table (also ~5 million rows of course)
>---
>GAME_ID
>VIEWS_COUNT
>PLAYED_COUNT
>PLAYED_COUNT_UNIQUE
This is a poor normalisation. While views_c
On 06/05/07 00:46, Erick Papadakis wrote:
Hi
Sorry for this somewhat long email but I think it is relevant to most
people who run online databases. I am having trouble optimizing UPDATE
queries on a certain semi-large table that is only growing larger.
I've come across some very interesting thou
