Vinicius - I'd be interested in learning more about your method. Can you point me to some reading or examples?
-Jim On Fri, Feb 6, 2015 at 4:48 AM, Vinicius Assef < list-web...@viniciusban.eu.org> wrote: > Dont't define a table the way you did. > > I.e, don't expect a return object from db.define_table() when creating a > lazy table because it doesn't exist, actually. > > About performance, I got good results simply setting "migrate=False" and > creating modules, instead of creating global functions in models. > > > > ---- On Thu, 05 Feb 2015 20:04:47 -0300 Jim S 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/XipyU9kQ2Qw/unsubscribe. > To unsubscribe from this group and all its topics, 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.