>>>
>>>Test 2. SQL SELECT a set of +/-21,000 records matching an index key field from a file containing +/- 10m records and about 800Mb in size.
>>>
>>
>>>VFP - my average time after several iterations/tests = +/-3 seconds
>>>WinDev 64 bit - my average time after several iterations/tests = +/-0.4 seconds
>>>
>>>Here WinDev is roughly a factor of 10 times faster than VFP in the SQL SELECT test. I am guessing they have spent more time on optimizing their SQL functionality.
>>
>>Hi Jos,
>>
>>just out of interest, have you ensured your VFP select is fully optimised?
>
>In both cases the files are indexed on a compound of 2 fields, an item id and a date field. In both cases the SQL SELECT is identical and is essentially - select * from myfile where item_id = req_id. i.e. select all the records where the item id matches a test value which results in 21,000 records+/-.
>
>I realize these types of tests are probably not real-world useful. I also realise that one can squeeze out performance enhancements in all sorts of ways. I am not trying to present a definitive comparison, just a casual one.
>
>Keep in mind that WinDev also can access almost any mainstream database as well as its own internal database. Plus, its own database, which they call HyperFile, comes in two modes of operation; (1) simple or classic mode which would be where users access the tables directly or (2) you can set up the HyperFile Client Server engine and let the HF server respond to client requests. I have read that you can switch a WinDev HyperFile Classic installation to Client/Server mode and back again although I have not tried that.
>
>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?