Thanks Anthony, this really helped confirm the lazy_tables=True is working as expected. On average I am using 8 to 10 tables out of 30 total per request depending on the URL visited. Here is the relevant output from httpserver.log when I ran the application through a sequence of operations. The applications are running on latest trunk as of Monday afternoon Aug 27.
Results for application before lazy_tables conversion 127.0.0.1, 2012-08-27 17:13:14, GET, /ccimsb/default/user/login, HTTP/1.1, 200, 0.040427 127.0.0.1, 2012-08-27 17:13:18, POST, /ccimsb/default/user/login, HTTP/1.1, 303, 0.046311 127.0.0.1, 2012-08-27 17:13:19, GET, /ccimsb/default/index, HTTP/1.1, 200, 0.085805 127.0.0.1, 2012-08-27 17:13:23, GET, /ccimsb/map/index, HTTP/1.1, 303, 0.040259 127.0.0.1, 2012-08-27 17:13:23, GET, /ccimsb/map/display/region/AK, HTTP/1.1, 200, 0.060424 127.0.0.1, 2012-08-27 17:13:25, GET, /ccimsb/map/display/site/VDZ, HTTP/1.1, 200, 0.064545 127.0.0.1, 2012-08-27 17:13:28, GET, /ccimsb/live/display/camera/VDZ/vdz-ca06, HTTP/1.1, 200, 0.249349 127.0.0.1, 2012-08-27 17:13:31, GET, /ccimsb/live/display/camera/VDZ/vdz-ca07, HTTP/1.1, 200, 0.433233 127.0.0.1, 2012-08-27 17:13:35, GET, /ccimsb/archive/site/VDZ, HTTP/1.1, 303, 0.118293 127.0.0.1, 2012-08-27 17:13:35, GET, /ccimsb/archive/display/menu/VDZ, HTTP/1.1, 200, 0.066299 127.0.0.1, 2012-08-27 17:13:36, POST, /ccimsb/archive/control/VDZ, HTTP/1.1, 200, 0.041629 127.0.0.1, 2012-08-27 17:13:37, POST, /ccimsb/archive/control/VDZ, HTTP/1.1, 200, 0.045691 127.0.0.1, 2012-08-27 17:13:40, GET, /ccimsb/default/user/logout, HTTP/1.1, 303, 0.047035 127.0.0.1, 2012-08-27 17:13:40, GET, /ccimsb/default/index, HTTP/1.1, 200, 0.042211 The applcation model converted to use lazy_tables 127.0.0.1, 2012-08-27 17:11:21, GET, /ccims/default/user/login, HTTP/1.1, 200, 0.075939 127.0.0.1, 2012-08-27 17:11:27, POST, /ccims/default/user/login, HTTP/1.1, 303, 0.060465 127.0.0.1, 2012-08-27 17:11:27, GET, /ccims/default/index, HTTP/1.1, 200, 0.089743 127.0.0.1, 2012-08-27 17:11:31, GET, /ccims/map/index, HTTP/1.1, 303, 0.029557 127.0.0.1, 2012-08-27 17:11:31, GET, /ccims/map/display/region/AK, HTTP/1.1, 200, 0.058424 127.0.0.1, 2012-08-27 17:11:36, GET, /ccims/map/display/site/VDZ, HTTP/1.1, 200, 0.057399 127.0.0.1, 2012-08-27 17:11:39, GET, /ccims/live/display/camera/VDZ/vdz-ca06, HTTP/1.1, 200, 0.220563 127.0.0.1, 2012-08-27 17:11:41, GET, /ccims/live/display/camera/VDZ/vdz-ca07, HTTP/1.1, 200, 0.450254 127.0.0.1, 2012-08-27 17:11:43, GET, /ccims/archive/site/VDZ, HTTP/1.1, 303, 0.030611 127.0.0.1, 2012-08-27 17:11:44, GET, /ccims/archive/display/menu/VDZ, HTTP/1.1, 200, 0.062489 127.0.0.1, 2012-08-27 17:11:44, POST, /ccims/archive/control/VDZ, HTTP/1.1, 200, 0.029913 127.0.0.1, 2012-08-27 17:11:49, POST, /ccims/archive/control/VDZ, HTTP/1.1, 200, 0.032068 127.0.0.1, 2012-08-27 17:11:54, GET, /ccims/default/user/logout, HTTP/1.1, 303, 0.064506 127.0.0.1, 2012-08-27 17:11:54, GET, /ccims/default/index, HTTP/1.1, 200, 0.030596 This is an improvement in performance for the new lazy_tables. The login and logout numbers are a bit longer for the new version but it doesn't matter for that. Thanks for the many improvements, Ron --
