>>>>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
>>
>>Get more RAM, you are close to the lower limit.
>
>The problem persists on my friends system a P4 with 256mb ram and winxp

256MB is also close to minimum, try 512MB or 1GB. For me anything less than 1GB is useless, I have 2GB on all my PCs.