<i><font color="#663300">In one of my recent project, I noticed a signifiacnt performance difference in REQUERY(). When 'Purcahse Order Line Items' table is REQUERY()-ed from command window, it takes SIGNIFICANTLY less time than REQUERY() issued through 'Purchase Order' form.</font></i>
[snipped]
<i><font color="#663300">REUSLTS:
For (1):4.256 seconds
For (2): 0.064 seconds
THE QUESTION:
(A) Can any one tell me why the huge time difference?
(B) Is this happening to me only?</font></i>
The Codebook form classes have code that sets the Session Environment; these settings may be different than the defaults you have set for your development environment. Specifically, you might have SET DELETED OFF as your default, while Codebook forms default to SET DELETED ON. Try running the same tests, but this time altering the the value of SET DELETED in your development environment.
<font color="#cc0000"> ___/
/
__/
/
____/</font>
Ed Leafe
©2002 Ed Leafe |
