good point. the select is in gluon/validators.py right now there is no option cache it.
Massimo On Dec 21, 11:56 am, vince <[email protected]> wrote: > i was trying to figure out how to cache select inside the SQLFORM. > let say > db.Field('info1',db.list), > db.Field('info2',db.list), > db.Field('info3',db.list), > > i tried to locate the select query inside SQLFORM in sqlhtml.py > > elif hasattr(field.requires,'options'): > opts=[] > for k,v in field.requires.options(): > opts.append(OPTION(v,_value=k)) > > can you show me some lights where is the actual select query. > in some cases if i have many field that is joining the same table it > will have over a second delay on just the SQLFORM function. > > -vince > > On Dec 21, 7:03 pm, mdipierro <[email protected]> wrote: > > > No it is not lazy evaluated. You can cache selects. > > > Massimo > > > On Dec 21, 2:15 am, vince <[email protected]> wrote: > > > > from my experience pylons should be the fastest one before i notice > > > web2py. i don't have any accurate data compare to pylons right now but > > > i guess it shouldn't have much different i think. if u need one i'll > > > try to build a sample benchmarking application for both pylons and > > > web2py later. > > > > one performance issue i notice on web2py is the sqlform/sqltable. if > > > you have 100 fields in a table u'll notice it. it makes it hard with > > > high concurrent visitors. although pylons' formbuilder is quite fast > > > but it's not fair to compare as it's not that powerful/handy. and i > > > think that can be fix easy by caching the sqlform result and replace > > > it. > > > > oh yeah one question. web2py's DAL is non-lazy query right? > > > > -vince > > > > > @vince > > > > do you have any data we can use to compare web2py to other frameworks? > > > > > Massimo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
