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

[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

[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 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