also is it possible to enable logging for all SQL query execution?
On Dec 22, 6:30 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> try the latest trunk IS_IN_DB(...cache=(cache.ram,3600))
>
> On Dec 21, 12:39 pm, vince <lapcc...@gmail.com> wrote:
>
> > 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 <mdipie...@cs.depaul.edu> 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 <lapcc...@gmail.com> 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 <mdipie...@cs.depaul.edu> wrote:
>
> > > > > No it is not lazy evaluated. You can cache selects.
>
> > > > > Massimo
>
> > > > > On Dec 21, 2:15 am, vince <lapcc...@gmail.com> 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 web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
