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: 336

Filed under:
|

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

Related posts about database

Related posts about Xml