I suspect you have tables which use represent to look up the
representation of each record.
for example:
db.define_table('item',
Field('name'),
Field('owner','reference auth_user'))
{{=SQLFORM.grid(db.item)}}
The grid needs to represent each owner. It is a user to will look up
the representation for the user. It needs first name and last name for
it, so it fetches each record.
This is not efficient.
If you could do joins (and on GAE you cannot) you would do a join:
{{=SQLFORM.grid(db.item.owner==db.auth_user.id,fields=[db.item.name,db.auth_user.first_name,db.auth_user.last_name)}}
On GAE the only option is pre-selecting all the users, storing their
name in a dict, caching the dict, redefine the representation of a
owner using the dict.
Massimo
On Jan 31, 12:39 pm, Sam Bolgert <sbolg...@gmail.com> wrote:
> Here is my log from the Google App Engine local dev server. I don't
> understand where all these "1"s are being printed from and what they
> mean. Some of these pages are just static and are not making any
> Datastore calls in the controller. Any insight would be helpful. Thank
> you.
>
> 2012-01-31 18:08:29,591 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,612 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,633 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,661 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,684 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,710 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,740 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,767 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,809 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,848 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,875 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,912 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,942 dal.py:3399] 1
> INFO 2012-01-31 18:08:29,992 dal.py:3399] 1
> INFO 2012-01-31 18:08:30,039 dal.py:3399] 1
> INFO 2012-01-31 18:08:30,069 dal.py:3399] 1
> INFO 2012-01-31 18:08:30,130 dal.py:3399] 1
> INFO 2012-01-31 18:08:30,158 dal.py:3399] 1
> INFO 2012-01-31 18:08:30,295 dal.py:3399] 1
> INFO 2012-01-31 18:08:30,326 dal.py:3399] 1
> INFO 2012-01-31 18:08:30,373 gaehandler.py:72] **** Request:
> 1106.70ms/893.63ms (real time/cpu time)
> INFO 2012-01-31 18:08:30,560 recording.py:372] Saved; key:
> __appstats__:009200, part: 98 bytes, full: 392182 bytes, overhead:
> 0.021 + 0.186; link:http://localhost:8080/_ah/stats/details?time=1328033309266
> INFO 2012-01-31 18:08:30,696 dev_appserver.py:2753] "GET /
> uwspcommute HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:30,746 dev_appserver_index.py:255] Updating /
> Users/samb/Documents/Transportation Project/project/web2py/index.yaml
> INFO 2012-01-31 18:08:30,843 dev_appserver.py:2753] "GET /
> uwspcommute/static/css/south-street/jquery-ui-1.8.16.custom.css HTTP/
> 1.1" 200 -
> INFO 2012-01-31 18:08:30,957 dev_appserver.py:2753] "GET /
> uwspcommute/static/css/calendar.css HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:31,042 dev_appserver.py:2753] "GET /
> uwspcommute/static/css/1140.css HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:31,138 dev_appserver.py:2753] "GET /
> uwspcommute/static/css/styles.css HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:31,224 dev_appserver.py:2753] "GET /
> uwspcommute/static/css/lectric.css HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:31,346 dev_appserver.py:2753] "GET /
> uwspcommute/static/js/lectric.js HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:31,454 dev_appserver.py:2753] "GET /
> uwspcommute/static/js/modernizr-1.7.min.js HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:31,586 dev_appserver.py:2753] "GET /
> uwspcommute/static/js/jquery-1.7.min.js HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:31,711 dev_appserver.py:2753] "GET /
> uwspcommute/static/js/jquery-ui-1.8.16.custom.min.js HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:31,841 dev_appserver.py:2753] "GET /
> uwspcommute/static/js/calendar.js HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:31,914 dev_appserver.py:2753] "GET /
> uwspcommute/static/js/web2py_ajax.js HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:32,060 dev_appserver.py:2753] "GET /
> uwspcommute/static/js/css3-mediaqueries.js HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:32,297 dev_appserver.py:2753] "GET /
> uwspcommute/static/images/logo.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:32,451 dev_appserver.py:2753] "GET /
> uwspcommute/static/slideshow/image_1.jpg HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:32,549 dev_appserver.py:2753] "GET /
> uwspcommute/static/slideshow/image_2.jpg HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:32,625 dev_appserver.py:2753] "GET /
> uwspcommute/static/slideshow/image_3.jpg HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:32,703 dev_appserver.py:2753] "GET /
> uwspcommute/static/slideshow/image_4.jpg HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:32,795 dev_appserver.py:2753] "GET /
> uwspcommute/static/slideshow/image_5.jpg HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:32,917 dev_appserver.py:2753] "GET /
> uwspcommute/static/fonts/com4s_m-webfont.woff HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,040 dev_appserver.py:2753] "GET /
> uwspcommute/static/fonts/Bevan-webfont.woff HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,149 dev_appserver.py:2753] "GET /
> uwspcommute/static/img/slider_right_arrow.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,216 dev_appserver.py:2753] "GET /
> uwspcommute/static/img/slider_left_arrow.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,287 dev_appserver.py:2753] "GET /
> uwspcommute/static/img/homepage_sidebox_li.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,355 dev_appserver.py:2753] "GET /
> uwspcommute/static/images/homepage_bus.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,438 dev_appserver.py:2753] "GET /
> uwspcommute/static/images/homepage_carpool.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,505 dev_appserver.py:2753] "GET /
> uwspcommute/static/images/homepage_commute.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,576 dev_appserver.py:2753] "GET /
> uwspcommute/static/images/homepage_walk.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,641 dev_appserver.py:2753] "GET /
> uwspcommute/static/images/homepage_bike.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,708 dev_appserver.py:2753] "GET /
> uwspcommute/static/images/facebook_logo.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,786 dev_appserver.py:2753] "GET /
> uwspcommute/static/images/footer_img.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,862 dev_appserver.py:2753] "GET /
> uwspcommute/static/img/content_bg.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:33,933 dev_appserver.py:2753] "GET /
> uwspcommute/static/img/homepage_sidebox_bg.png HTTP/1.1" 200 -
> INFO 2012-01-31 18:08:52,377 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,396 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,424 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,456 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,480 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,592 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,613 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,634 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,670 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,716 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,745 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,773 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,804 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,866 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,900 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,930 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,959 dal.py:3399] 1
> INFO 2012-01-31 18:08:52,997 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,029 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,065 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,097 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,134 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,162 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,193 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,221 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,264 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,302 dal.py:3399] 1
> INFO 2012-01-31 18:08:53,351 gaehandler.py:72] **** Request:
> 1025.46ms/1015.05ms (real time/cpu time)
> INFO 2012-01-31 18:08:53,570 recording.py:372] Saved; key:
> __appstats__:032300, part: 111 bytes, full: 439623 bytes, overhead:
> 0.022 + 0.218; link:http://localhost:8080/_ah/stats/details?time=1328033332326
> INFO 2012-01-31 18:08:53,714 dev_appserver.py:2753] "GET /
> uwspcommute/survey/index HTTP/1.1" 200 -
> INFO 2012-01-31 18:09:53,058 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,076 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,095 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,119 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,143 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,173 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,193 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,226 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,265 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,311 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,340 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,373 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,406 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,461 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,491 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,521 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,552 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,596 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,623 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,660 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,686 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,718 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,753 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,786 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,818 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,864 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,904 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,933 dal.py:3399] 1
> INFO 2012-01-31 18:09:53,933 gaehandler.py:72] **** Request:
> 948.13ms/948.86ms (real time/cpu time)
> INFO 2012-01-31 18:09:54,146 recording.py:372] Saved; key:
> __appstats__:092900, part: 120 bytes, full: 449538 bytes, overhead:
> 0.025 + 0.212; link:http://localhost:8080/_ah/stats/details?time=1328033392985
> INFO 2012-01-31 18:09:54,300 dev_appserver.py:2753] "POST /
> uwspcommute/survey/index HTTP/1.1" 303 -
> INFO 2012-01-31 18:09:54,439 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,459 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,483 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,505 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,531 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,560 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,585 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,610 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,650 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,687 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,721 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,760 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,792 dal.py:3399] 1
> INFO 2012-01-31 18:09:54,840 dal.py:3399] 1
> INFO
> ...
>
> read more »
