Hi Robert,

IMO, the existing FoxPro behavior for this is important especially when you have recursive functions - you may want to make those variables local for each recursion.. So, for me, the FoxPro behavior is right on these situations.

I forgot to mention that I have 1000 records in my TEMP.DBF. When I reduced this to 100 records, I have the same result as yours.

Hmmm, yours is faster at 8 seconds? Is this the "SKIP" example? or the "LOCATE" example. The 8 seconds for me is the "LOCATE" example.
But on the "SKIP' example, see my attached screenshot here with FConvertToMemoryStream(DbInfo(DBI_FILEHANDLE)) enabled.

So the case is different in VFP/X#, it looks like VO/X# performs a little bit better.

I tried to redirect the file stream into memory in VFP/X# and the difference is not much (minus 2-3 seconds).

I don't use VO/X# so I can't compare.

<r>Hi Leon,<br/> Thanks for being interested on this topic as I am taking application performance very seriously as well. I have applications with heavy lifting algorithms and haven't tried them yet in X# as I came across this performance issue.<br/> <br/> Would you mind to test this code as well ...

<r>Hi Robert/Chris,<br/> <br/> I tried to add <CODE><s>[code]</s>FConvertToMemoryStream(DbInfo(DBI_FILEHANDLE))<e>[/code]</e></CODE> but it only reduced to 6 seconds from 8 seconds. Still slow compared to FoxPro at less than 1 sec.<br/> <br/> The reason why the speed is a big deal for me is that I ...

<r>Hey Guys,<br/> <br/> I came across this website below while google searching and found this discussion about X# very interesting:<br/> <br/> <URL url="https://support.west-wind.com/Thread5U70W2EQW.wwt">https://support.west-wind.com/Thread5U70W2EQW.wwt</URL><br/> <br/> Anyone here using Web ...

<r>Hi lumberjack,<br/> <br/> Your simple code change did not improve the speed in X#. Still at <B><s>[b]</s>8 seconds<e>[/b]</e></B>, see my screenshot attached. <br/> <br/> <QUOTE><s>[quote]</s>forget about the "LOCATE" speed, but look at what features of X# you can use to speed up your code<e ...

<r>Sorry for throwing more issues here as I am trying to test out X# if moving our apps to this technology would be feasible <E>:)</E><br/> <br/> With SET OPTIMIZE OFF, I created a small dbf table (no index) with 1000 records to test the speed of LOCATE command in both X# and VFP.<br/> I iterate a ...

Hi Chris,
See attached screenshot and a sample Temp.dbf file