Re: [sqlite] sqlite-users Digest, Vol 11, Issue 76

2008-11-25 Thread Constantine Vassil
I am wondering is somebody compiled SQLite with Intel IPP using 32 bit memory alignment for alloc speedup? Thanks, Constantine ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Window functions

2008-11-24 Thread Constantine Vassil
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