I'm working with the LiveGrid using php and mysql.  If I use the 
LiveGrid with a query that returns a large number of rows there's a lot 
of overhead caused by the need to count the entire query.

From what I see, it appears that the get_total parameter to the data 
source is supposed to control that...where get_total=false will prevent 
it from trying to determine the total number of rows.  I've been trying 
to test that by modifying the code used in ex3.php, but somehow I'm just 
not understanding exactly how to implement that.  It seems as though the 
Rico javascript automatically adds that query string parameter to the 
ajax calls.

Can anyone clear me as to what I'm missing there?  Thanks in advance.

Tom

I figured out how to do this by adding:

requestParameters:[{name:'get_total',value:'true'}]

...to the buffer options when creating the Rico.Buffer.AjaxSQL.  One 
issue however, that I'll probably post as a new topic on the Sourceforge 
forums, is this:

When using this option where you don't get the total record count (the 
display shows 1-xxx of about yyy), when the grid needs to get data it 
never seems to display the "Waiting for Data" message.  This can be 
really confusing as it just simply appears to be locked up while 
retrieving data.

Tom

For the record, the above was supposed to read:

requestParameters:[{name:'get_total',value:'false'}]

Tom