> Once I complete Visual FreePro, that limitation will no longer exist (Visual FreePro bypasses all space barriers allowing for as many records as you have disk space). This could explain why I have not received help thus far ... perhaps deep down people know what completing VFrP means. :-)
>
>So VFrP will query a clickstream table with over a trillion rows? Any benchmarks you can share? You've got my curiosity.

It's logical ... if I maintain the current table header structure compatibility, I'm limited to 4.3 billion records of up to almost 64KB each, which is 281 TeraBytes. The memo files allow 4.3 billion blocks of up to 64KB each as well, which is about the same. However, in general most tables will only be a few KB per row, which is more like 13 TeraBytes. And, of course, there are limitations to the current query model.

Visual FreePro 2.0 has a new database engine design that I have not released publicly, called "Journey." It does things differently, and queries will not take as long as they do today in virtually every case.