According to your model you have two references:
1) joernaal.id (with autocomplete)
2) article.ouid (without)
How many records do you have in joernaal and in article tables?.
On Jan 28, 6:54 am, Johann Spies <johann.sp...@gmail.com> wrote:
> On 28 January 2011 13:30, Lucas D'Avila <lucass...@gmail.com> wrote:
>
> > Hi !
>
> > You can be more specific? have any suggestions to improve this?
>
> OK. For the following model, calling DAL.create it takes 65 seconds to open
> the form using web2py's own webserver and 35 seconds when using Apache +
> WSGI. Both too long:
>
> db.define_table("artikel",
> Field("joernaal_id",
> db.joernaal,
> requires = IS_IN_DB(db, db.joernaal.id,
> '%(titel)s')),
> # widget =SQLFORM.widgets.autcomplete),
> Field("outeur_id", 'list:reference outeur'),
> Field("instansie_id", 'list:reference instansie'),
> Field("titel", "string", notnull=True),
> Field("opsomming", "text", notnull=True),
> Field("sleutelwoorde", "text", notnull=True),
> Field("vakgebied", "string", default=None),
> Field("publikasiejaar", "integer", default=None),
> Field("begin_bladsy", default=None),
> Field("laaste_bladsy", default=None),
> Field("volume", "string", default=None),
> Field('uitgawe', default=None),
> Field('pub_tipe', default = None),
> Field("taal", "string", default=None),
> Field("isi_indeks", default = None),
> Field("isap_indeks", default = None),
> Field("scopus_verwysing",
> requires=IS_EMPTY_OR(IS_URL())),
> Field("dokument_tipe"),
> Field('ouid', 'integer',
> requires = IS_EMPTY_OR(IS_IN_DB(db, 'article.ouid'))),
> signature)
>
> I don't know what is causing this. I just guess it may the reference
> fields.
>
> 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
