KGS Game Archives: suggestion for improvement

[walleye]

Is there any particular reason why KGS Game Archives give links to months even if the player didn't play any games in those months?
It is perfectly capable of filtering the months before the first game and after the last game. Why does it not filter the empty months in between.

For example, here's a link to the first month of Yamabushi (for no particular reason)

http://www.gokgs.com/gameArchives.jsp?u ... 03&month=6

There is a table on the page with links to different months when presumably Yamabushi played some games.
The table gives the impression Yamabushi played some games in every month from Jun 2003 to Feb 2007.
This is not the case, however. Most of the months are empty.

It would be nice if those empty months were not displayed.

[wms]

The links to empty months are there because otherwise I'd have to search a player's whole game list to find which months have games and which don't. The archive pages already are the main load for the web server, this would only make them significantly worse.

I also can't precompute which months people have games because, based on the time zone of the viewer, the games may move from one month to another.

When the server I use gets upgraded I may add the code to check at runtime for which months have games, but that's at least a year off.

[Li Kao]

I also can't precompute which months people have games because, based on the time zone of the viewer, the games may move from one month to another.

I would have used UTC for that without a second thought. Do you mean that even the monthly zip file you can download is different depending on where the user resides? I would have expected that the zip files get cached and are the same for everyone.

[wms]

Well, the date and time of all games shown is in your local time. Anything else would be inconvenient at best. It would be confusing if you saw a game dated July 1 on the June page, so it follows that the month breakdown also has to be localized. And for the zip file to have something different from what you see in the list would, again, be confusing, so yes, when you download a monthly zip file the files are selected based on your local time.

The zip files are not cached, they are generated on the fly. Selecting the files in the database probably takes at least 10 times the CPU power and disk space compared to making the zip file so it would be pointless to cache them. Getting the list of games requires a 5-way join across tables, some of which have over 80,000,000 rows, so this is going to dominate any work done in the archives.