Smart rendering issue

Suite and Optimus Suite 5
#1

I use a DHTMLX Grid with Smart rendering (buffer 50). It works fine.
Nevertheless I’m using a database with an important number of data (several millions), and I have to deal with performances issues

Each time, I launched a search, an HTTP request is send to server. I send two SQL requests, one to fetch the first 50 rows, and one other to count the total number of results. Then this results are sent back in JSon to the client-side.

The Select query is fast since it’s optimized. But the count(*) request takes much more time (up to 4 minutes). So in order to optimize all of this, I want to dissociate the two SQL queries in two HTTP requests. The first one will retrieve the first 50 rows, and the second one (running in background) will retrieve the total number of rows. This solution works, BUT I have trouble with the Smart Rendering, when the first query comes back (with the first 50 rows), the smart rendering initialize itself on this 50 rows, and when the second request comes back, the smart rendering do not update the vertical scroll, so it’s impossible to view more than the first 50 rows.

I wonder if there is a way to make the smart rendering works, with two requests instead of one.

Here my code:

// Here the two HTTP requests 
p_mygrid.post(request, JSONtoURLString(parameters), function () {
	p_mygrid.post(currentCountQueryUrl, JSONtoURLString(parameters),'json');
}, 'json');
#2

You can try the next

grid.rowsBuffer[max_count] = grid.rowsBuffer[max_count]||null; grid._reset_view();

#3

First, thanks you for your help.

Your solution seems not to solve my problem, or maybe I don’t really understand it.
Nevertheless, I find a solution which works for my problem.

//request = URL to get 50 rows 
//currentCountQueryUrl = URL to count all the rows
p_mygrid.post(request, JSONtoURLString(parameters), function () {
		p_mygrid._fillers = undefined; //For the vertical scroll bar

                /** Removing the last empty <tr> tag **/
		len = p_mygrid.obj.rows.length;
		var t_r = p_mygrid.obj.rows[len-1];
		t_r.parentNode.removeChild(t_r);
		
		p_mygrid.post(currentCountQueryUrl, JSONtoURLString(parameters),function(){
			/** Set the url for the smart rendering **/
			p_mygrid.xmlFileUrl = request;
		},'json');
		}
	, 'json');