Talk:Maintenance DEV: Difference between revisions

From AniDB
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
Hmm, don't know if this is actually useful, but a mix of DirtyBlock and update some of the stats on the stats on the fly would probably be the best alternative, the slave doesn't sound very good..
Hmm, don't know if this is actually useful, but a mix of DirtyBlock and update some of the stats on the stats on the fly would probably be the best alternative, the slave doesn't sound very good..
The user stats for an anime/ep/file could be probably be calculated on event (add file to mylist, remove file from mylist), file/ep count the same.
The user stats for an anime/ep/file could be probably be calculated on event (add file to mylist, remove file from mylist), file/ep count the same.
group stats could use the dirty block, no loss there.
group stats could use the dirty block, no loss there.
user stats is the main problem, definitely dirty block here, but i would make the added to db stuff on event (add/remove anime, last anime added to mylist, date of last mylist addition) the rest i would make on request of info, the user probably won't request the data much so no much need to update that data that often.
user stats is the main problem, definitely dirty block here, but i would make the added to db stuff on event (add/remove anime, last anime added to mylist, date of last mylist addition) the rest i would make on request of info, the user probably won't request the data much so no much need to update that data that often.


Though the trigger issues brought up is tricky indeed... -fahrenheit
Though the trigger issues brought up is tricky indeed... -fahrenheit

Revision as of 23:55, 13 May 2007

Hmm, don't know if this is actually useful, but a mix of DirtyBlock and update some of the stats on the stats on the fly would probably be the best alternative, the slave doesn't sound very good.. The user stats for an anime/ep/file could be probably be calculated on event (add file to mylist, remove file from mylist), file/ep count the same.


group stats could use the dirty block, no loss there.


user stats is the main problem, definitely dirty block here, but i would make the added to db stuff on event (add/remove anime, last anime added to mylist, date of last mylist addition) the rest i would make on request of info, the user probably won't request the data much so no much need to update that data that often.


Though the trigger issues brought up is tricky indeed... -fahrenheit