Jim,
As far as I can see and from which I know about lazy_table you already
lazy_table compliant...
What have been said about it application or not once flag is set to true
was that you must not define your validator outside model definition (you
actually do that in your example)...
You can't do :
db.define_table('productSequenceTag',
Field('productSequenceTagId', 'id',
readable=False),
Field('productId', db.product, label=
'ProductId'),
Field('sequenceTagId', db.sequenceTag,
label='Sequence Tag', ondelete='RESTRICT'),
plural='Seq Tags')
db.productSequenceTag.productId.requires = IS_IN_DB(db, 'product.id',
'%(productNumber)s
- %(productName)s',
zero='..')
But you don't do that actually...
Richard
On Thu, Feb 5, 2015 at 6:04 PM, Jim S <j...@qlf.com> wrote:
> Hi
>
> I need to take advantage of the performance boost available using
> lazy_table=True.
>
> My problem is that I have lots of table definitions in db.py that look
> like this:
>
> productSequenceTag = db.define_table('productSequenceTag',
> Field('productSequenceTagId', 'id',
> readable=False),
> Field('productId', db.product, label=
> 'ProductId',
> requires=IS_IN_DB(db, '
> product.id', '%(productNumber)s - %(productName)s',
> zero='..')),
> Field('sequenceTagId', db.sequenceTag
> , label='Sequence Tag', ondelete='RESTRICT'),
> plural='Seq Tags')
>
>
> There isn't much on the subject in the book, but there are a number of
> good threads here in the group. However, it is really hard (for me at
> least) to sift through all this info and know definitively what is the best
> way to define a table and make sure it is lazy.
>
> Has anyone successfully implemented lazy_tables on a large db project?
> I've got 155 tables in my application.
>
> I really need to find a way to make this load quicker. Any help would
> really be appreciated.
>
> -Jim
>
> --
> 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/d/optout.
>
--
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/d/optout.
