Hi Massimo, I double checked and all foreign keys are declared as "reference table_name". I also used the {{=response.toolbar()}} and looking at the tables item I see the expected tables are defined for each function and tables not in use are indeed lazy. All the pages except the initial landing page are @auth.requires_login() in the controller.
I might have a bad test case, not many tables, fairly complex views. The benchmark results for the shell based test are running very fast in sub microsecond times so even a dozen of those would add up to very little in the total service time of the pages in this app. Thanks Ron On Tuesday, 28 August 2012 09:35:35 UTC-7, Massimo Di Pierro wrote: > > I'd expect something better. Add {{=response.toolbar()}} to your layout. > It will tell you which tables are lazy and which ones are now. Make you do > no have more tables than you need. > > For example using Field('....',db.auth_user) forces db.auth_user even if > not needed. Field('....','reference auth_user') will keep it lazy. > > On Monday, 27 August 2012 19:27:27 UTC-5, Ron McOuat wrote: >> >> >> 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 >> >> --