json response is very slow.

Ankit Shukla

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..

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dharmraj Thakur9y ago
Accepted 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;
Kanak9y ago
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}]
Ankit Shukla9y ago
How can I optimize them Sir. Their is any other way to fetch records?
Dharmraj Thakur9y ago
There is to much conditions and to much manual conversion... It can be optimize...
Ankit Shukla9y ago
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
Dharmraj Thakur9y ago
Its based on how you are featching and displaying data on your page...
Please show if you like
Ravi Sangtani9y ago
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.