Hi,
I switched to using trunk(r19714) to avoid row count being fetched
several times on remote table being loaded and now the app loads fine,
but firebug console has 2 errors:
> qx.log.appender.Util is undefined
> [Break on this error] console[entry.level].call(cons...e,
> qx.log.appender.Util.toText(entry));\nNative.js (line 55)
> qx.lang.Core is undefined
> [Break on this error] Stack.prototype.indexOf =
> qx.lang.Core.arrayIndexOf;\nBaseArray.js (line 489)
Any idea on why this happens and what to do to eliminate the errors?
Also, I'm using remote table and previously while using 0.8.2, when I
pressed <End> key to reach end of my table data, it fetched the last row
indefinitely, until I pressed <Home> to return to first page, when it
stopped fetching the last page. The row count method on the server was
also accessed around 14 times on table loading.
Now, when I use trunk, the initial 14 requests have disappeared, and
only 1 request is sent to get row count and first set of row data. Also
<End> gets the last page only once from the server. But, if I press
<Pageup> to visit the last but 1 page, it goes on infinitely asking for
that page's data.
I've got 2951 sample rows in my table. Also, I'm using
> m.setBlockSize(100);
> m.setMaxCachedBlockCount(3);
See the rails side requests received from qooxdoo below:
> Processing DataController#get_row_count (for 127.0.0.1 at 2009-07-30
> 18:40:19) [GET]
> Parameters: {"nocache"=>"1248959418923",
> "authenticity_token"=>"auth_token_here"}
> SQL (3.6ms) SELECT count(*) AS count_all FROM "data_logs"
>
> [http://127.0.0.1/data/get_row_count?nocache=1248959418923&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:40:19) [GET]
> Parameters: {"from"=>"0", "nocache"=>"1248959419512",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"199", "sortOrder"=>"asc"}
> DataLogs Load (8.4ms) SELECT * FROM "data_logs" WHERE (id >= 0 AND
> id <= 199) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=0&to=199&sortOrder=asc&sortIndex=-1&nocache=1248959419512&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:38) [GET]
> Parameters: {"from"=>"2800", "nocache"=>"1248959557847",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2999", "sortOrder"=>"asc"}
> DataLogs Load (6.5ms) SELECT * FROM "data_logs" WHERE (id >= 2800
> AND id <= 2999) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2800&to=2999&sortOrder=asc&sortIndex=-1&nocache=1248959557847&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:42) [GET]
> Parameters: {"from"=>"2700", "nocache"=>"1248959562868",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2799", "sortOrder"=>"asc"}
> DataLogs Load (7.1ms) SELECT * FROM "data_logs" WHERE (id >= 2700
> AND id <= 2799) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2700&to=2799&sortOrder=asc&sortIndex=-1&nocache=1248959562868&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:43) [GET]
> Parameters: {"from"=>"2800", "nocache"=>"1248959563315",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2899", "sortOrder"=>"asc"}
> DataLogs Load (5.5ms) SELECT * FROM "data_logs" WHERE (id >= 2800
> AND id <= 2899) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2800&to=2899&sortOrder=asc&sortIndex=-1&nocache=1248959563315&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:43) [GET]
> Parameters: {"from"=>"2700", "nocache"=>"1248959563606",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2799", "sortOrder"=>"asc"}
> DataLogs Load (5.7ms) SELECT * FROM "data_logs" WHERE (id >= 2700
> AND id <= 2799) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2700&to=2799&sortOrder=asc&sortIndex=-1&nocache=1248959563606&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:44) [GET]
> Parameters: {"from"=>"2800", "nocache"=>"1248959563900",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2899", "sortOrder"=>"asc"}
> DataLogs Load (5.6ms) SELECT * FROM "data_logs" WHERE (id >= 2800
> AND id <= 2899) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2800&to=2899&sortOrder=asc&sortIndex=-1&nocache=1248959563900&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:44) [GET]
> Parameters: {"from"=>"2700", "nocache"=>"1248959564321",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2799", "sortOrder"=>"asc"}
> DataLogs Load (6.1ms) SELECT * FROM "data_logs" WHERE (id >= 2700
> AND id <= 2799) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2700&to=2799&sortOrder=asc&sortIndex=-1&nocache=1248959564321&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:44) [GET]
> Parameters: {"from"=>"2800", "nocache"=>"1248959564653",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2899", "sortOrder"=>"asc"}
> DataLogs Load (5.7ms) SELECT * FROM "data_logs" WHERE (id >= 2800
> AND id <= 2899) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2800&to=2899&sortOrder=asc&sortIndex=-1&nocache=1248959564653&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:45) [GET]
> Parameters: {"from"=>"2700", "nocache"=>"1248959565053",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2799", "sortOrder"=>"asc"}
> DataLogs Load (6.1ms) SELECT * FROM "data_logs" WHERE (id >= 2700
> AND id <= 2799) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2700&to=2799&sortOrder=asc&sortIndex=-1&nocache=1248959565053&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:45) [GET]
> Parameters: {"from"=>"2800", "nocache"=>"1248959565336",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2899", "sortOrder"=>"asc"}
> DataLogs Load (7.0ms) SELECT * FROM "data_logs" WHERE (id >= 2800
> AND id <= 2899) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2800&to=2899&sortOrder=asc&sortIndex=-1&nocache=1248959565336&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:46) [GET]
> Parameters: {"from"=>"2700", "nocache"=>"1248959566312",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2799", "sortOrder"=>"asc"}
> DataLogs Load (5.5ms) SELECT * FROM "data_logs" WHERE (id >= 2700
> AND id <= 2799) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2700&to=2799&sortOrder=asc&sortIndex=-1&nocache=1248959566312&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:46) [GET]
> Parameters: {"from"=>"2800", "nocache"=>"1248959566713",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2899", "sortOrder"=>"asc"}
> DataLogs Load (5.9ms) SELECT * FROM "data_logs" WHERE (id >= 2800
> AND id <= 2899) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2800&to=2899&sortOrder=asc&sortIndex=-1&nocache=1248959566713&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:47) [GET]
> Parameters: {"from"=>"2700", "nocache"=>"1248959567008",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2799", "sortOrder"=>"asc"}
> DataLogs Load (6.5ms) SELECT * FROM "data_logs" WHERE (id >= 2700
> AND id <= 2799) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2700&to=2799&sortOrder=asc&sortIndex=-1&nocache=1248959567008&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:47) [GET]
> Parameters: {"from"=>"2800", "nocache"=>"1248959567476",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2899", "sortOrder"=>"asc"}
> DataLogs Load (5.5ms) SELECT * FROM "data_logs" WHERE (id >= 2800
> AND id <= 2899) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2800&to=2899&sortOrder=asc&sortIndex=-1&nocache=1248959567476&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:47) [GET]
> Parameters: {"from"=>"2700", "nocache"=>"1248959567793",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2799", "sortOrder"=>"asc"}
> DataLogs Load (5.5ms) SELECT * FROM "data_logs" WHERE (id >= 2700
> AND id <= 2799) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2700&to=2799&sortOrder=asc&sortIndex=-1&nocache=1248959567793&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:48) [GET]
> Parameters: {"from"=>"2800", "nocache"=>"1248959568086",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2899", "sortOrder"=>"asc"}
> DataLogs Load (6.1ms) SELECT * FROM "data_logs" WHERE (id >= 2800
> AND id <= 2899) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2800&to=2899&sortOrder=asc&sortIndex=-1&nocache=1248959568086&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:42:48) [GET]
> Parameters: {"from"=>"2700", "nocache"=>"1248959568494",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2799", "sortOrder"=>"asc"}
> DataLogs Load (6.4ms) SELECT * FROM "data_logs" WHERE (id >= 2700
> AND id <= 2799) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2700&to=2799&sortOrder=asc&sortIndex=-1&nocache=1248959568494&authenticity_token=auth_token_here]
> Processing DataController#get_table_data (for 127.0.0.1 at 2009-07-30
> 18:45:52) [GET]
> Parameters: {"from"=>"2800", "nocache"=>"1248959752726",
> "sortIndex"=>"-1", "authenticity_token"=>"auth_token_here",
> "to"=>"2899", "sortOrder"=>"asc"}
> DataLogs Load (5.5ms) SELECT * FROM "data_logs" WHERE (id >= 2800
> AND id <= 2899) ORDER BY id asc
>
> [http://127.0.0.1/data/get_table_data?from=2800&to=2899&sortOrder=asc&sortIndex=-1&nocache=1248959752726&authenticity_token=auth_token_here]
Any idea why this happens? Maybe I'm doing something wrong?
cheers,
skar.
--
--
The life so short, the craft so long to learn.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
qooxdoo-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
