Save match details to SQLite or XML?
Posted
by
trizz
on Programmers
See other posts from Programmers
or by trizz
Published on 2012-06-13T08:02:15Z
Indexed on
2012/06/13
10:47 UTC
Read the original article
Hit count: 366
I'm making a (conceptual) system to simulate any kind of sports match (like soccer,basketball,etc) with actions (for example pass,pass,out,pass,score) so it will be like a real report. The main statistics (play time, number of actions etc.) I'm saving to a MySQL database, but the report itself, can contain more than 1000 actions per match.
To avoid millions of records in my database I'm thinking of saving the detailled report in a SQLite database or a XML file. For every match played, a file will be created. When a user request the match details, I read the file for details.
What is the best choice for this purpose? SQLite or XML?
© Programmers or respective owner