I have a C# Windows Forms project which uses a Sql Server Compact (SDF) database for only retrieving data. My application does not update the database. Thus the database is static. I recently read somewhere that for such kind of static work it is best to use XML or JSON as they reduce the I/O time which is spent on connecting to the database, retrieving,and closing the database. Is this true?
If So, is there a way by which I can directly convert my database contents to that of a JSON file? It has 7 tables(relations) now and total of 850 rows(tuples) of data. The data is in Kannada language and not English(if this makes any diff).
Aucun commentaire:
Enregistrer un commentaire