Wilson,
I looked at your code, and that seems to me as to what I did? Now the example of 3 nested DO WHILEs was different of course because in that case I also took advantage of indexes and added the FOR clause on the SCAN loop to be optimizable.
--Michael
------------------------------------------------
On Fri, 31 Jan 2003 14:12:31 -0500, "Wilson M. Kierstead" <wil at vfpbizapps .DOT com> wrote:
<snipped>
> Therefore, an apples to apples test would be as follows:
>
> * Test While loop -Start
> SELECT table
> ltstart = datetime()
> GO TOP
> do while !EOF()
> skip
> enddo
> ? datetime() - ltstart && show number of seconds taken to skip through
> entire table
> * Test While loop -End
>
> * Test Scan loop -Start
> SELECT table
> ltstart = datetime()
> SCAN
> ENDSCAN
> ? datetime() - ltstart && show number of seconds taken to skip through
> entire table
> * Test Scan loop -End
>
> Wilson KIerstead
©2003 profox at cpvfug D.OT org |
