>>>I think the best thing you can do is to read "The Ultimate Power & Speed of VFP" by Val Matison in FoxPro Advisor, March, 1997. He talks about his experience with the application he wrote for the Euro Tunnel. About 128GB of data!
>>>
>>>I hope you are aware of the limitation of 2GB per table in VFP... :)
>>>
>>>Vlad
>>>
>>>>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?
>>
>>If I remember correctly, it has something to do with the way VFP locks records, using "virtual" locks with a values beyond 2^31.
>
>I know nothing about this. Can you send me to more info on this issue? Thanks.
>
>Vlad

I will. I've been on vacation but I return to work tomorrow and work is where my source books are. If I remember correctly the info came from a FoxPro Advisor article. Let you know tomorrow
If I forget (we have a big 9:00 am meeting tomorrow) drop me an email reminder.
Jerry