Will WIndows know where to build the swap files? In other words, if you have a drive C: with your system temp directory, etc. with about 1 Gb free and you have this new drive with 2 Gb free, will Windows use the C:, the D:, or both?

Just curious...

BTW, the best price/Gb right now is probably 6.4 GB drives (at least in Canada for EIDE drives...)...

Joe

>Thanks - that was my estimate also. At least 3 gig hard drive
>
>>My guess is that you will need an additional 2GB of disk space to complete the process. VFP will try to use the memory as much as possible, but I doubt that you have 1GB of RAM! So VFP will create a swap file of 1GB before creating the real table.
>>
>>>I am working with tables approximately 1 gigabyte in size, give
>>>or take a mega!! My problem is that I have to run an SQL on
>>>the table that orders it for another application to use.
>>>
>>>Select * from datafile order by field1 into table xyz
>>>
>>>How much Hard Drive do I need for this to function? Where
>>>do the buffer sit? in memory or hard drive or both?
>>>We've already decided to run this off a PC as opposed to
>>>off a server in order to speed up the process.