Meta data


Label: Order Entry Vindication Order Entry Vindication Order Entry Vindication Order Entry Vindication Order Entry Vindication Order Entry Vindication Order Entry Vindication Order Entry Vindication
Folder: OrderEntryVindication OrderEntryVindication OrderEntryVindication OrderEntryVindication OrderEntryVindication OrderEntryVindication OrderEntryVindication OrderEntryVindication
Time stamp: 20120518-150915 20120518-151233 20120518-151324 20120518-151355 20120518-152413 20120518-154053 20120518-155111 20120518-210307
Display label: Local data Remote data Open client 2 on remote data Edit record client 2 Edit record on server No_Relate_State not set All tables closed No_Relate_State set again
Description:

Test environment


TableQuery version: 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97
Computer name: STURE-PC STURE-PC STURE-PC STURE-PC STURE-PC STURE-PC STURE-PC STURE-PC
Zero Select Time: n/a n/a n/a n/a n/a n/a n/a n/a
Debugger present: No No No No No No No No
VDF version 17.0 17.0 17.0 17.0 17.0 17.0 17.0 17.0
Operating system: Windows 7 (32 bit) Windows 7 (32 bit) Windows 7 (32 bit) Windows 7 (32 bit) Windows 7 (32 bit) Windows 7 (32 bit) Windows 7 (32 bit) Windows 7 (32 bit)
Time of execution: 18-05-2012 17:09:15,05 18-05-2012 17:12:33,103 18-05-2012 17:13:24,216 18-05-2012 17:13:55,158 18-05-2012 17:24:13,282 18-05-2012 17:40:53,348 18-05-2012 17:51:11,515 18-05-2012 23:03:07,247
Total excution time: 8,701 9,652 9,36 322,887 323,876 350,318 318,842 319,107

Parameters, scalars


Customer/OrderHea/OrderDtl. A 3-level loop that finds 488 records in total. Each loop is called 25 times (grand total 12200 records) and the time it takes to do that is recorded.
DataDictionaries (ms) 2893 3420 3157 162894 161695 191220 159601 159335
Clear/Move/Repeat/Find (ms) 368 451 452 29087 29340 28854 29184 29366
TableQuery (ms) 1981 2132 2109 34256 34757 34584 33225 33177
TableQueryStructure (ms) 2734 2852 2846 34677 35899 34672 34832 35163
Customer full table scan. 100 records. Again it is called 25 times for each strategy.
DataDictionaries (ms) 2 529 583 583 46263 46167 46038 46663 45666
Clear/Move/Repeat/Find (ms) 2 39 48 48 7408 7662 7088 7081 7282
TableQuery (ms) 2 157 166 164 8301 8355 7862 8078 8949

Parameters, arrays