list:reference fields get an IS_IN_DB validator if no explicit requires is defined. Note: the assigned requires is not a list.
On Jan 28, 12:54 pm, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > Something else is wrong. If you have requires=[...] it should not > query the db for the possible references and it should not make the > dropdown. > > Can we see the entire model? > > Massimo > > On Jan 28, 10:01 am, Johann Spies <johann.sp...@gmail.com> wrote: > > > On 28 January 2011 16:45, Massimo Di Pierro > > <massimo.dipie...@gmail.com>wrote: > > > > This: > > > > requires = IS_IN_DB(db, db.joernaal.id, '%(titel)s') > > > > indicates you want to a select/options dropbox and it takes time to > > > populate it. > > > > Use instead: > > > > requires = [IS_IN_DB(db, db.joernaal.id,'%(titel)s')] > > > > so no dropbox and use autocomplete. > > > Thanks for the suggestion which is an improvement but it did not make a > > difference in the speed. The form still takes about 70 seconds to show up. > > I suspect the list_references may be the culprit. Maybe I must redisign the > > database structure to handle 1 to many relationships differently. > > > Regards > > Johann > > -- > > May grace and peace be yours in abundance through the full knowledge of God > > and of Jesus our Lord! His divine power has given us everything we need for > > life and godliness through the full knowledge of the one who called us by > > his own glory and excellence. > > 2 Pet. 1:2b,3a > >