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