[web2py] Re: SQLFORM very slow when table is big

Ok Thank you Niphlod, just found in manual this: If you want the field validated, but you do not want a drop-down, you must put the validator in a list.db.dog.owner.requires = [IS_IN_DB(db, 'person.id', '%(name)s')] hahaha sorry I was desperate to solve my problem.. Thanks! On Sunday,

[web2py] Re: SQLFORM very slow when table is big

Oh ok I got it... I just forgot about this b/c I use a manual autocomplete function... I was using IS_IN_DB just as a validator to make sure user don't try to input wrong value I think I`ll make one validator just for validate user... Do you think this is a good idea to add to the framework?

[web2py] Re: SQLFORM very slow when table is big

IS_IN_DB() is a validator. Usually you need it to turn a foreign key to a human-understandable value, or to let the human select values from a set. Depending on your model and on the number of values available, generating the default widget in an edit form, which is an html SELECT, can take