[tmql-wg] Proposed new requirement: Paging of result sets

Lars Marius Garshol larsga@garshol.priv.no
03 Jul 2003 18:30:18 +0200


A very common requirement in application development is to have the
ability to

  a) limit the number of results produced by a query, and

  b) do paging of result sets so that they can be presented to users
     in blocks 1-15, 16-30, 31-45, ...

This can be done without support for this feature in the query
language, but the query language can be made more effective if it
supports this directly.

Based on this, what do people think of the following requirements:

  "TMQL shall provide features for specifying the number of query
  results returned by a query; similar to SQL's LIMIT feature."

  "TMQL shall provide feature for paging of query results by providing
  features that perform similar functions to SQL's LIMIT and OFFSET."

Comments?

-- 
Lars Marius Garshol, Ontopian         <URL: http://www.ontopia.net >
GSM: +47 98 21 55 50                  <URL: http://www.garshol.priv.no >