ParamQuery grid support forum
General Category => Help for ParamQuery Pro => Topic started by: dataSQL_ on January 04, 2017, 06:34:10 am
-
I believe I can resolve the time out issue.
Question please, I purchased ParamQuery believing that it was FAST in loading remote data as well as displaying / presenting that same data extremely well.
1. My data, at present seems to have a long load time issue with only a few records.
2. My grid looks horrible and the ROLL UP does not function.
I am going to review all your documentation this evening on how to resolve the visual issue.
I am going to create a default html table and see if the same time to load is a coding issue or a ParamQuery issue.
Any suggestions, greatly appreciated.
-
I found this on the forum.
http://paramquery.com/forum/index.php?topic=1888.0
"it shouldn't take more than a second to load data in grid in virtual mode irrespective of number of rows"
why would I need to create special code to extend the load time due to a time out error?
I am being mislead, something is not right, and I cannot yet figure it out.
Any thoughts?
I should not have to write special code with.ebextensions to extend the TIME OUT for less than 100 rows of data.
Please, the JSON string loads fast but PQGrid won't load it - the error message says PROXY ERROR, but the logs say TIME OUT.
Please, any thought?
I don't know everything, but with guidance, I can find the solution.
-
Server ---- data over internet/ intranet --> Browser [ ParamQuery grid ]
Paramquery grid runs in browser, its virtual rendering makes the data rendering fast when data is available in browser. Data binding of ParamQuery grid is very fast ~100 ms.
Time out errors has nothing to do with ParamQuery grid, it means the server is slow.
Easy way to verify it is by opening the url (shared by you in previous post ) in the browser.
-
Amazon servers are not slow.
http://35.167.46.75/faces/index.xhtml
The JSON string loads locally instantly.
something in the index.xhtml is causing a delay to invoke the TIME OUT during load.
If the JSON string is not the delay, there is nothing else involved except the VIEW and the javascript function in the VIEW.
INDEX.XHTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
xmlns:ui="http://xmlns.jcp.org/jsf/facelets"
xmlns:h="http://xmlns.jcp.org/jsf/html"
xmlns:f="http://xmlns.jcp.org/jsf/core"
xmlns:c="http://java.sun.com/jsp/jstl/core">
<h:head>
<link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.2/themes/base/jquery-ui.css"/>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"/>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.9.2/jquery-ui.min.js"/>
<h:outputStylesheet name="css/pqgrid.min.css"/>
<h:outputScript name="js/pqgrid.min.js"/>
<h:outputScript name="js/jquery.ui.touch-punch.js"/>
<script>
$(function()
{
var dataModel =
{
error: function(a, b, c)
{ alert(b);
alert(c);
alert(a.responseText);
console.log(a.responseText);},
location: "remote",
dataType: "JSON",
method: "GET",
url: "queryreturn",
getData: function (dataJSON) {
return { curPage: dataJSON.curPage, totalRecords: dataJSON.totalRecords, data: dataJSON.data };
}
}
var obj = {};
obj.dataModel = dataModel;
obj.width = 700;
obj.height = 400;
obj.colModel = [
{ title: "Person ID", width:100, dataType: "int", dataIndx: "person_id"},
{ title: "Last Name", width:150, dataType: "string", dataIndx: "lastname"},
{ title: "First Name", width:150, dataType: "string", dataIndx: "firstname"},
{ title: "Full Name", width:200, dataType: "string", dataIndx: "fullname"},
];
$("div#grid_array").pqGrid( obj );
});
</script>
</h:head>
<h:body>
Grid is below<br>
</br>
<div id="grid_array"></div>
</h:body>
</html>
-
The url from where you fetch json data is quite slow and there is a 502 proxy server error which has nothing to do with javascript in your view.
http://35.167.46.75/faces/queryreturn?pq_datatype=JSON&_=1483520368823
Grid won't be able to display data unless you provide data to it.