>Hi,
>
>How do you compare the speed between two SQL Select expressions?
>Typically I would do it like this:
>
>nStart = seconds()
>select * ......
>nEnd = seconds()
>nTime = nEnd - nStart
>
>
>What I am not sure is how do you account for the fact that the 1st SQL Selects creates some data buffer (I think it does but I am not sure). So, if the buffering assumption is correct, the 2nd SQL Select will have an advantage.
>Another approach, I think, is to do 1st SQL Select. Then, shut down VFP and on the next start to do 2nd SQL Select only.
I wrote about this stuff here:
http://tomorrowssolutionsllc.com/ConferenceSessions/Cant%20this%20application%20go%20any%20faster.PDFTamar