json response is very slow.

Question

Hello I have a json API: https://web.fulcrumapp.com/shares/ee99463260c9cf3d.json Their are only 216 reords (4 columns) now. But When I am fetching these records and shows in datagrid It takes 20-25 seconds to display. Their should be 1000s of records in future. Client is complaining about it. What can I do? Please help..

Dharmraj Thakur · Answer

As I tried below you can see... DataTable dtEvents1; HttpWebRequest http = (HttpWebRequest) HttpWebRequest.Create( https://web.fulcrumapp.com/shares/ee99463260c9cf3d.json ); HttpWebResponse response = (HttpWebResponse) http.GetResponse(); responseJson = new StreamReader(response.GetResponseStream()).ReadToEnd(); string text = responseJson; JObject datas1 = JObject.Parse(text); JArray items = (JArray) datas1[ records ]; dtEvents1 = new DataTable(); dtEvents1.Columns.Add( Effective Date ); dtEvents1.Columns.Add( Project Name ); dtEvents1.Columns.Add( Tester Name / Observer ); dtEvents1.Columns.Add( Test Records ); dtEvents1.Columns.Add( ID ); for ( int i = items.Count - 1; i >= 0; i--) { dtEvents1.Rows.Add(); { int rowcounts = dtEvents1.Rows.Count; int rowno = rowcounts - 1; dtEvents1.Rows[rowno][0] = datas1[ records ][i][ form_values ][ 8487 ].ToString(); dtEvents1.Rows[rowno][1] = datas1[ records ][i][ form_values ][ 9fd5 ][ choice_values ][0].ToString(); dtEvents1.Rows[rowno][2] = datas1[ records ][i][ form_values ][ 0afa ].ToString(); dtEvents1.Rows[rowno][3] = string .Concat(((JArray) datas1[ records ][i][ form_values ][ 759f ]).Count.ToString()  Items ); dtEvents1.Rows[rowno][4] = i.ToString(); } } dataGridView1.DataSource = dtEvents1;

Kanak · Answer

Can u reduce the json file content 1.please remove key string lenth to small E.g) client_created_at--->cca 2.or chage json format key pair value into Array json E.g) [{ null 3 ab04c22f-7cf9-4db0-a25b-29e269f788dd 2016-11-14T19:48:17Z 2016-11-14T19:50:36Z 2016-11-14T19:39:57Z 2016-1114T19:50:33Z Tranzcorp Employee 47f8436d-a8ef-4921-a77a-6e8139166f00 Tranzcorp Employee 47f8436d-a8ef-4921-a77a-6e8139166f00 493 25 524 212354ab-284f-48f0-ad7e-1ccff5cdab8a null null null}{ null 3 ab04c22f-7cf9-4db0-a25b-29e269f788dd 2016-11-14T19:48:17Z 2016-11-14T19:50:36Z 2016-11-14T19:39:57Z 2016-1114T19:50:33Z Tranzcorp Employee 47f8436d-a8ef-4921-a77a-6e8139166f00 Tranzcorp Employee 47f8436d-a8ef-4921-a77a-6e8139166f00 493 25 524 212354ab-284f-48f0-ad7e-1ccff5cdab8a null null null}]

Dharmraj Thakur · Answer

There is to much conditions and to much manual conversion... It can be optimize...

Ankit Shukla · Answer

Hello My code is below: HttpWebRequest http = (HttpWebRequest)HttpWebRequest.Create(https://web.fulcrumapp.com/shares/ee99463260c9cf3d.json); HttpWebResponse response = (HttpWebResponse)http.GetResponse(); using (StreamReader sr = new StreamReader(response.GetResponseStream())) { responseJson = sr.ReadToEnd(); } string text = responseJson; JObject datas1 = JObject.Parse(text); JArray items = (JArray)datas1[records]; int length = items.Count; dtEvents1 = new DataTable(); dtEvents1.Columns.Add(Effective Date); dtEvents1.Columns.Add(Project Name); dtEvents1.Columns.Add(Tester Name / Observer); dtEvents1.Columns.Add(Test Records); dtEvents1.Columns.Add(ID); for (int i = length -1 ; i >= 0; i--) { if (datas1[records][i][form_values] != null) { if (!string.IsNullOrWhiteSpace(Convert.ToString(datas1[records][i][form_values][8487]))) { EffectiveDate = datas1[records][i][form_values][8487].ToString(); } else { EffectiveDate = null; } } else { EffectiveDate = null; } if (!string.IsNullOrWhiteSpace(Convert.ToString(datas1[records][i][form_values][9fd5]))) { ProjectName = datas1[records][i][form_values][9fd5][choice_values][0].ToString(); } else { ProjectName = null; } if (!string.IsNullOrWhiteSpace(Convert.ToString(datas1[records][i][form_values][0afa]))) { TesterName = datas1[records][i][form_values][0afa].ToString(); } else { TesterName = null; } if (datas1[records][i][form_values][759f] != null) { JArray Records = (JArray)datas1[records][i][form_values][759f]; int TotRecords = Records.Count; TestRecords = string.Concat(TotRecords.ToString()  Items); } else { TestRecords = 0 Items; } dtEvents1.Rows.Add(); { int rowcounts = dtEvents1.Rows.Count; int rowno = rowcounts - 1; dtEvents1.Rows[rowno][0] = EffectiveDate; dtEvents1.Rows[rowno][1] = ProjectName; dtEvents1.Rows[rowno][2] = TesterName; dtEvents1.Rows[rowno][3] = TestRecords; dtEvents1.Rows[rowno][4] = i.ToString(); } } dataGridView1.DataSource = dtEvents1; Thank You

Ravi Sangtani · Answer

I think you have to put navigation on your json data. when you request the url add parameter of start and limt in you query. that will return only 30 records or 50 how many you want. when request next then show next 30 or 50 records and so on.... I think it will not takes more times.

Ankit Shukla · Answer

How can I optimize them Sir. Their is any other way to fetch records?

Dharmraj Thakur · Answer

Its based on how you are featching and displaying data on your page... Please show if you like