OLAP functionality includes the concept of a sliding *window* that moves down through the input rows as they are processed. Additional calculations can be
performed on the data in the window as it moves, allowing further analysis in a manner that is more efficient than using semantically equivalent self-join queries, or correlated subqueries. I am thinking this functionality is possible to implement working directly with the B-Tree. Does anyone has better ideas? Thanks, Constantine _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users