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: |
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 |
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 |