>>Lastly, HyperFile in both modes solves all VFP database issues like
>>
>>> 2Gb limits
>>> encryption
>>> replication
>>> full text searching on text/memo fields
>>> built in database design and relationship managment
>>> data dictionary
>>> automatic database configuration changes to end-users installation
>>> automatic database creation if files dont exist or are added to the model
>>
>>and more I guess - still learning myself ...
>
>:) sorry, was just wanting to know if the VFP query was fully optimised, not questioning what you were doing. WinDev is one of the tools I am considering and it would help me to know things like this, so in order to know if the speed comparison was accurate I was just wondering if you had run SYS(3054) to see if the query was optimised. Could you do that and let me know, if you have th etime, please?

In addition, if I then scan through the resulting cursor and extract some data from it then I get these results:

VFP - using DO WHILE - ENDDO loop on the whole cursor = +/-2.3 seconds
VFP - using SCAN -ENDSCAN loop on the whole cursor = +/- 0.04 seconds (fastest)
WinDev - using a WHILE - END loop on the whole cursor = +/- 0.5 seconds

There are other WinDev loop options and options for processing cursors but I have not tested them all and so dont know if there are faster ones or not (like a SCAN ENDSCAN for example).