On Monday, November 4, 2013 1:23:59 PM UTC-5, Annet wrote: > Thanks for your reply. I had a look at the shortcuts in the book: > > http://web2py.com/books/default/chapter/29/06/#Shortcuts > > The first shortcut makes a significant difference in performance >
The first shortcut is for a select. It says this: myrecord = db.mytable[id] is equivalent to: myrecord = db(db.mytable.id==id).select().first() But in fact, it is really equivalent to this: myrecord = db(db.mytable.id==id).select(limitby=(0, 1), orderby_on_limitby=False).first() You shouldn't notice any performance difference in comparison to the latter. so I thought maybe this: > > db.mytable[0] = dict(myfield='somevalue') > > an impact on performance too? > > No, the above will not be any faster. If anything, it could be ever so slightly slower because it requires a call to ._filter_fields(). Anthony -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
