What's faster working with databases or json ( assuming that the data will be around 300 rows in the database )?

What's faster working with databases or json ( assuming that the data will be around 300 rows in the database ) ?
For WinRT apps?
September 19th 19 at 13:33
2 answers
September 19th 19 at 13:35
And how many columns? :)
IMHO for 300 records, it is possible not to think about such matters, use what You prefer.
id int (300) name (nvarchar length 200 x 300 ) description (nvarchar max x 300 )
path (nvarchar max x 300) pathvideo ( nvarchar length 100 x 300 ) - lucie_Hagenes commented on September 19th 19 at 13:38
5 columns
I just did AsyncReadAllLines with a regular file
that gave me 3-4 seconds loading
in the file there were 3 entries each 5 rows
a total of 15 rows = 3-4 seconds...
now dislike Async - lucie_Hagenes commented on September 19th 19 at 13:41
I think there is not in the Async case. - edison.Jenkins commented on September 19th 19 at 13:44
: and what? :With - lucie_Hagenes commented on September 19th 19 at 13:47
: show code. At such volumes should be read instantly. - osvaldo83 commented on September 19th 19 at 13:50
: right. No code little to say. Maybe You have some tricky parsing. Either the description field is VERY LARGE. Either in the main thread that it is considered.
What to the original question, ask it. Specify the used DB and move the WinRT in the title. Better chance of an accurate and correct answer. - edison.Jenkins commented on September 19th 19 at 13:53
September 19th 19 at 13:37
Converting it to datauri after Uri = new Uri("ms-appx:///DataModel/TextFile1.txt");
 StorageFile file = await StorageFile.GetFileFromApplicationUriAsync(converting it to datauri after);
 IList<string> localList;
 localList = new List<string>();
 localList = await FileIO.ReadLinesAsync(file);
 for (int i = 0; i < localList.Count; i += 8)
{
 commonWidget.Add(new Widget
{
 Id = Convert.ToInt32(localList[i]),
 Name = localList[i+1],
 Bithday = localList[i+2],
 Description = localList[i + 4],
 ImagePath = localList[i + 3],
 Career = localList[i + 5]
});
 }</string></string>

Find more questions by tags JSONC#SQL