From: Hank R. <ha...@cr...> - 2006-11-30 17:02:24
|
Hello, I make some queries that simply cannot be optimized because they compare so many elements. In a sql database, I would make the query once and use a cursor to page through the result. The REST interface conveniently returns the @hits, @start and @count. Perhaps I am doing something else wrongly, but calling the same query again, with a new _start still appears to process the whole long query again. Has there been some discussion of a result that persists for the session, so that the same query with and new _start works like a cursor? Thank you, Hank Hank Ratzesberger NEES Programmer Institute for Crustal Studies University of California, Santa Barbara |