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
-~----------~----~----~----~------~----~------~--~---
