<i><font color="#663300">Running the TestRequery.prg in my development environment gave the following results:
(A) With SET DELETED OFF : 0.031 seconds
(B) With SET DELETED ON : 0.050 seconds
After running the above tests, I have created index on DELETED() in both 'Purchase Order' and 'Purchase Order Line Items' tables and REQUERY()-ed through the form. But there was no significant improvement in performance.</font></i>
OK, then it's not your SET DELETED setting. But it has to be something else in the environment, since you are measuring the time it takes a native VFP command, REQUERY(), and not any kind of code. SET DELETED was the most likely culprit.
BTW, if you expect to run your app across a network, you shouldn't index on DELETED(). See <a href="http://fox.wikis.com/wc.dll?Wiki~NonDiscriminatingIndex~VFP" target="_new">http://fox.wikis.com/wc.dll?Wiki~NonDiscriminatingIndex~VFP</a> for an explanation as to why.
<font color="#cc0000"> ___/
/
__/
/
____/</font>
Ed Leafe
©2002 Ed Leafe |
