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     2012-01-31 18:09:54,873 dal.py:3399] 1
INFO     2012-01-31 18:09:54,914 dal.py:3399] 1
INFO     2012-01-31 18:09:54,941 dal.py:3399] 1
INFO     2012-01-31 18:09:54,990 dal.py:3399] 1
INFO     2012-01-31 18:09:55,017 dal.py:3399] 1
INFO     2012-01-31 18:09:55,057 dal.py:3399] 1
INFO     2012-01-31 18:09:55,083 dal.py:3399] 1
INFO     2012-01-31 18:09:55,114 dal.py:3399] 1
INFO     2012-01-31 18:09:55,146 dal.py:3399] 1
INFO     2012-01-31 18:09:55,179 dal.py:3399] 1
INFO     2012-01-31 18:09:55,208 dal.py:3399] 1
INFO     2012-01-31 18:09:55,244 dal.py:3399] 1
INFO     2012-01-31 18:09:55,282 dal.py:3399] 1
INFO     2012-01-31 18:09:55,336 dal.py:3399] 1
INFO     2012-01-31 18:09:55,336 gaehandler.py:72] **** Request:
956.29ms/960.58ms (real time/cpu time)
INFO     2012-01-31 18:09:55,567 recording.py:372] Saved; key:
__appstats__:094300, part: 113 bytes, full: 457693 bytes, overhead:
0.023 + 0.231; link: http://localhost:8080/_ah/stats/details?time=1328033394380
INFO     2012-01-31 18:09:55,728 dev_appserver.py:2753] "GET /
uwspcommute/survey/address HTTP/1.1" 200 -
INFO     2012-01-31 18:09:55,782 dev_appserver_index.py:255] Updating /
Users/samb/Documents/Transportation Project/project/web2py/index.yaml
INFO     2012-01-31 18:09:56,142 dev_appserver.py:2753] "GET /
uwspcommute/static/css/south-street/images/ui-bg_highlight-
soft_95_ffedad_1x100.png HTTP/1.1" 200 -
INFO     2012-01-31 18:09:56,251 dev_appserver.py:2753] "GET /
uwspcommute/static/css/south-street/images/ui-icons_cd0a0a_256x240.png
HTTP/1.1" 200 -
INFO     2012-01-31 18:09:56,328 dev_appserver.py:2753] "GET /
uwspcommute/static/css/south-street/images/ui-bg_highlight-
hard_100_f5f3e5_1x100.png HTTP/1.1" 200 -
INFO     2012-01-31 18:09:56,417 dev_appserver.py:2753] "GET /
uwspcommute/static/css/south-street/images/ui-bg_gloss-
wave_100_ece8da_500x100.png HTTP/1.1" 200 -
INFO     2012-01-31 18:09:56,530 dev_appserver.py:2753] "GET /
uwspcommute/static/css/south-street/images/ui-bg_highlight-
hard_15_459e00_1x100.png HTTP/1.1" 200 -
INFO     2012-01-31 18:17:38,756 dev_appserver.py:2753] "GET /
uwspcommute/static/css/south-street/images/ui-bg_highlight-
hard_100_fafaf4_1x100.png HTTP/1.1" 200 -
INFO     2012-01-31 18:17:38,833 dev_appserver.py:2753] "GET /
uwspcommute/static/css/south-street/images/ui-bg_highlight-
soft_25_67b021_1x100.png HTTP/1.1" 200 -

On Jan 31, 11:21 am, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> You cannot just swith from the datastore to gae:sql. They are
> different databases. To use the latter you need to setup an instance
> for it. Google has documentation about it.
>
> Anyway, that may solve your problem or make it worse. First of all you
> need to identify why you have to many read operations.
>
> massimo
>
> On Jan 31, 9:38 am, Sam Bolgert <sbolg...@gmail.com> wrote:
>
>
>
>
>
>
>
> > Hi all,
>
> > For my current project I am making an interactive survey application for a
> > environment research project. Its currently hosted on GAE.
> > My problem is my Datastore read operations are through the roof. A few
> > users can max the quota in about an hour.
>
> > Ive tried switching DAL adapters from gae:datastore to gae:sql but not my
> > app just doesn't work. Anyone else have this problem??

Reply via email to