I use Oracle. It is unbeliavable performance when paging or sorting. In milli seconds, i see the data on paging.
Qx0.7.2, IE6, Oracle 9i/10g. I also use the remote table with default page limit & offsets. What is your database? Oracle uses something lke rownum and rowid features helped me lot. We also use Sybase, we see the performance hit like you. In order to pull last 100 of 10,000 rows, Sybase has to load/scan all the records in memory. It is like File based system. If you use Oracle, something is wrong with Oracle tuning then. Thanks. hipe it helps. Burak Arslan-4 wrote: > > all, > > the current method to produce responses to remote table models is to use > the underlying database's limit & offset method. while being the > simplest solution, offsetting is either > > 1) slow > 2) fast when the query is cached on the server side, but then it's > costly in memory. > > i don't think this problem has a %100 solution. > > but i see an optimization opportunity: the table could make the job of > the database management system much easier by sending the sorting key > from the last row of the previous block, if it's already fetched. (or > analogously, the sorting key from the first row of the next block, if > it's already fetched. > > this way, the sql query can be: > > (...) where (...) and id > 200000 limit 50 > > instead of > > (...) limit 50 offset 128475 > > the former query will instantly sweep off the initial rows, while the > latter will iterate over the initial rows only to ignore them. > > do you think implementing this would be worth the effort ? > > awaiting your feedback, > > best regards > burak > > ------------------------------------------------------------------------------ > OpenSolaris 2009.06 is a cutting edge operating system for enterprises > looking to deploy the next generation of Solaris that includes the latest > innovations from Sun and the OpenSource community. Download a copy and > enjoy capabilities such as Networking, Storage and Virtualization. > Go to: http://p.sf.net/sfu/opensolaris-get > _______________________________________________ > qooxdoo-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel > > -- View this message in context: http://www.nabble.com/faster-responses-to-remote-table-models-tp23867224p23874912.html Sent from the qooxdoo-devel mailing list archive at Nabble.com. ------------------------------------------------------------------------------ OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get _______________________________________________ qooxdoo-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
