Interrogator Users: Giant CSVs or per-season CSVs?

[gstelmack]

For the guys using Interrogator: I'm getting ready to dump player game stats and past season transactions out. The question is: should there be a single giant CSV for each of these tables, or would you prefer a CSV per season? The season will be included as a column regardless.

[Taco]

Thanks for asking. I would prefer a single giant CSV file. I end up converting the csv files into SQL files for insertion into a MySql database, and having all of this data in one table instead of a separate table for each season is much nicer. If there were separate files for each season I could still deal with it, but it makes it slightly easier in a single file.

[marcmoustache]

Ditto Taco, much easier as one file with all seasons in it.

[MrBigglesworth]

Our league puts the tables into a MySQL database as well, if there are multiple seasons in one file would it ever get so big that it would make it a problem uploading it every week to the relatively cheap hosts we use?

[marcmoustache]

Maybe, 15 mb at a time. I'm going to cross post this in the general FOF2k7 suite thread.

[3ric]

One big file, as long as the current season's stats and transactions are in a separate file.

[cuervo72]

I *think* distinct seasons, just seems more manageable to me. Though if any data columns might change at some point, I could see one big file.