Meta data


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:

Test environment


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

Parameters, scalars


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

Parameters, arrays