Need help structuring a table (or two)

[mattal999]

Hi,

 

I am aiming to do something along the lines of this website, http://tweet-tunes.com/, which stores how many times an artist has been tweeted in the past and up to the present. Now I can retrieve the data, that's easy, but I am not sure on how to go about storing it.

 

At the moment I have this:

 

id artist date total

------------------------------------------------------------

1 beyonce 2009-12-11 4

 

And then for each new day I duplicate this row (using a script) starting at 0 and then carrying out the mining process. However, as I am going to have 5000+ rows the script takes far too long to duplicate these rows.

 

Is there a more efficient way of doing this? I need daily counts, just to be clear.

 

Thanks.

[fenway]

Don't store totals -- store the raw data.