Label: | Publ->Kam->Udva | Publ->Kam->Udva | Publ->Kam->Udva | Publ->Kam->Udva |
Folder: | PublKamUdva | PublKamUdva | PublKamUdva | PublKamUdva |
Time stamp: | 20120519-225502 | 20120521-105357 | 20120521-120050 | 20120519-164935 |
Display label: | Local MS SQL | LAN | Internet access 0.1 km | Internet access 100 km |
Description: |
TableQuery version: | 0.97 | 0.97 | 0.97 | 0.97 |
Computer name: | STURE-PC | STURE-PC | STURE-PC | STURE-PC |
Zero Select Time: | 1ms | 3ms | 28ms | 46ms |
Debugger present: | No | No | No | No |
VDF version | 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) |
Time of execution: | 20-05-2012 00:55:02,951 | 21-05-2012 12:53:57,714 | 21-05-2012 14:00:50,122 | 19-05-2012 18:49:35,073 |
Total excution time: | 329,321 | 2147,102 | 13803,337 | 21437,374 |
Going through Publishers/Orders/Series. | ||||
Publ record count | 91 | 91 | 91 | 91 |
Kam record count | 15821 | 15821 | 15821 | 15821 |
Udva record count | 289812 | 289812 | 289812 | 289812 |
Part 1. Force embedded | ||||
1. Total time | 101430 | 1784438 | 12838812 | 20062255 |
1. Inner loop records total | 289812 | 289812 | 289812 | 289812 |
1. Inner loop speed | 2857 | 162 | 23 | 14 |
Part 2. ESQL without inner join | ||||
2. Total time | 91302 | 225064 | 826988 | 1231640 |
2. Inner loop records total | 289812 | 289812 | 289812 | 289812 |
2. Inner loop speed | 3174 | 1288 | 350 | 235 |
Part 3. ESQL with inner join | ||||
3. Total time | 136132 | 137529 | 137134 | 142782 |
3. Inner loop records total | 289812 | 289812 | 289812 | 289812 |
3. Inner loop speed | 2129 | 2107 | 2113 | 2030 |