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
