oh thx i got it. can i propose a quick patch to add an optional argument to SQLFORM for passing the cache option to IS_IN_DB.options?
-vince On Dec 22, 2:11 am, mdipierro <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
