On Tue, Jan 12, 2010 at 14:18, <i...@saksys.de> wrote:
this is my rds script, its yours but extended with some sorting and
filtering stuff
Ok, a few suggestions.
First, create a subset of your database that contains only about 400
rows, and ensure that things work.
Next, I'm pretty concerned about this sorting stuff. I recommend
using exactly my example subclass of the remote data model, and
slightly modify your backend to accommodate that, for the moment.
Then you're working with known-working code on the frontend, and you
can ensure that you're sending the correct data from the backend and
that even with the huge database, it sorts correctly. Also, set all
columns to "not sortable" for the moment.
Once that's working, then modify the remote data model's subclass to
start thinking about sorting. I have a strong suspicion that remote
data model and client-side sorting don't play well together. I know
I've never tried that, and it intuitively (in my mind) doesn't work.
I suspect you'll find that it's spending oodles of time trying to
sort something. The remote model does some kind of sorting in cache,
but I haven't followed through the code to try to figure out exactly
what it's doing.
Derrell
/*
*
* Copyright:
* (c) 2008 by Derrell Lipman
*
* License:
* LGPL: http://www.gnu.org/licenses/lgpl.html
* EPL: http://www.eclipse.org/org/documents/epl-v10.php
* See the LICENSE file in the project's top-level directory for
details.
*
* Authors:
* Derrell Lipman (derrell)
*
*/
qx.Class.define("toppreis.RemoteDataModel",
{
extend : qx.ui.table.model.Remote,
construct : function()
{
this.base(arguments);
// Our data will be sent as an array of maps. Each map (one row
of data)
// will have properties "year" and "leap".
this.setColumnIds
([
"art_name",
"shp_marke",
"shp_produkt",
"shp_deeplink",
"shp_aktiv",
"shp_kategorie",
"shp_markt",
"shp_segment",
"shp_refnummer",
"shp_preis",
"shp_img",
"shp_verfuegbar",
"shp_gewicht",
"shp_volumen",
"shp_ean",
"shp_lieferkosten",
"shp_pzb",
"shp_ISBN",
"shp_aktion"
]);
//this.setColumnRenderer();
// Get an RPC object on which we'll do all of our communication
var clazz = toppreis.RemoteDataModel;
this.rpc = new qx.io.remote.Rpc(clazz.URL, clazz.SERVICE);
this.rpc.setTimeout(50000);
this.rpc.setCrossDomain(false);
},
// Configure these as appropriate for your server and services
statics :
{
// The URL for remote services.
URL : "../services/",
// The service to use. We expect this service to implement two
methods:
// getRowCount and getRowData.
SERVICE : "qooxdoo.toppreis"
},
members :
{
rpc : null,
tcm : null,
searchID : 0,
setSearchID : function(id)
{
this.searchID=id;
},
getSearchID : function()
{
return this.searchID;
},
filter : [],
setFilter : function(filter)
{
this.filter=filter;
},
getFilter : function()
{
return this.filter;
},
setTCM : function(tcm)
{
this.tcm=tcm;
},
// overloaded
_loadRowCount : function()
{
// Create the handler for our remote procedure call
var _this = this;
handler = function(result, ex, id)
{
mycall = null;
if (ex !== null)
{
alert("Async(" + id + ") exception: " + ex +
"<p>" +
"Are you sure you configured
rpcexample.RemoteDataModel.URL " +
"and rpcexample.RemoteDataModel.SERVICE?");
}
else
{
// We got (presumably) valid data. Apply it to the table
_this._onRowCountLoaded(result);
}
}
// Issue the call to get the row count
var req = this.rpc.callAsync(handler, "getRowCount",
this.getSearchID(),
this.getFilter());
},
_loadRowData : function(firstRow, lastRow)
{
// Create the handler for our remote procedure call
var _this = this;
handler = function(result, ex, id)
{
mycall = null;
if (ex !== null)
{
alert("Async(" + id + ") exception: " + ex +
"<p>" +
"Are you sure you configured
rpcexample.RemoteDataModel.URL " +
"and rpcexample.RemoteDataModel.SERVICE?");
}
else
{
// We got (presumably) valid data. Apply it to the table
_this._onRowDataLoaded(result);
//_this.setColumnRenderer();
}
}
// Issue the call to get the row count
// get the column index to sort and the order
var sortIndex = this.getColumnId(this.getSortColumnIndex());
var sortOrder = this.isSortAscending() ? "asc" : "desc";
var req = this.rpc.callAsync(handler, "getRowData", firstRow,
lastRow, sortIndex, sortOrder, this.getSearchID(),
this.getFilter());
}
}
});
> On Tue, Jan 12, 2010 at 13:51, Mustafa Sak <i...@saksys.de> wrote:
>
>> Hi Derrell
>> I am using exactly the RDS class from the contrib. In firebug i
can see
>> both async requests an the answers. The calls are needing less
than 5
>> seconds. The result just gets 200 rows at once.
>>
>
> Ok, that's good confirmation. The next thing to do is determine
where it's
> getting stuck. You were to implement the methods _loadRowCount() and
> _loadRowData() in your class that extends
qx.ui.table.model.Remote. Please
> post those two methods that you implemented so we can see what's
wrong.
>
> Derrell
>
---
---
---
---------------------------------------------------------------------
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution
fast and
> easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> _______________________________________________
> qooxdoo-devel mailing list
> qooxdoo-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
>
---
---
---
---------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast
and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
qooxdoo-devel mailing list
qooxdoo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
---
---
---
---------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast
and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
qooxdoo-devel mailing list
qooxdoo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
