>>>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?
>
>When I change the index so that the SQL SELECT can be fully optimised in both WinDev HyperFile and in VFP database then both tools return the dataset in +/-0.01 seconds.

cool! Thanks for checking it out and keep these updates coming. I may not respond as I am busy on another couple projects but I do read them with interest.