Actually I was considering not partitioning the drive in order to
avoid the issue completely.
>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.