Hi,
The results you are getting are about right for this vintage of hardware, I would upgrade the hardware to the following:

CPU minimum 3.2Ghz P4 (Preferably a dual core)
Intel Chipset
1GB Ram (especially when manipulating this amount of data)
SATA HDD or Ultra320 SCSI (These are much faster than what you are using)
Windows XP SP2 (I also assume you are using W98 or W2K)


>>Hi,
>>
>>What is the CPU speed and memory of the hardware you running this on.
>>Also if you are running on a network what are its details, speed etc.
>>
>>I am running similar queries on our next software version at present, the DBF has over 10M records and it extracts 2K records in 0.04 secs, it runs a bit slower accross the network, but not enough to worry about.
>>
>>The hardware is a 3.0Ghz P4 with 512MB Ram & 40GB free disk space.
>>
>>Are you running a virus checker.
>
>This a AMD atholon 2100+ with 128mb ram, AVg free virus edition and no network