>
>I think you're fooled by the fact Ko and I both come from the netherlands. I was refering to my private message regarding the controling buffersize when opening tables. Small tables (not more than a few kb) open significantly faster than larger than larger tables.
>
>I concluded that this was caused by VFP which tries to chache a certain amounts of bytes (I believe I read this at least depends whether the file was opened Exclusive or Readonly; more data will be cached). If tables are smaller than this amount of bytes, they seem to be opened faster.
>
>I've tested an application trough a 256 kb WAN, and came to the conclusion that smaller table openen in 1 or 2 seconds, while larger tables took about 10-15 seconds to open.
>
>To tune applications working with WAN (or even LAN) connections I would be nice if there was a possibility to tune the openfile performance by adjusting the buffersize of opened tables. I believe that this could solve at least some of the slow form instantiations, because the dataenvironment should be loaded faster as it does now.
>
>>Anyway, I can't reproduce your problems, even with the form you supplied (tried on three machines). Those VFP7 bits you have are pretty moldy compared to what I'm running, so those problems probably have already been fixed.
>
>This was Ko's problem, indeed.
>
Walter,
Are you just USEing the table or are you setting the index in the same command? It is definately faster to USE MyTable then SET ORDER TO MyTag in two different commands.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer