I have a process that produces about 22 million records a month (about 1.2 gigabytes). I would like to query about four months worth of data at a time (100 million records or just over 6 gigabytes).

I have only written apps up through FoxPro 2.6 since 1989, and have never dreamed of tackling anything like this, but opportunity is knocking. Anybody have an approach to this, both from a software and hardware perspective?