I think you need manually create index(es) in the database.
2011/1/28 Johann Spies <johann.sp...@gmail.com> > I have a lot of foreign keys in a database of which some tables have more > than 300000 records. What is happening is that if a link to add a record > is selected it takes a long time before the form appears because all the > cross referencess in the IS_IN_DB-dropdowns have to be assembled. > > How do I speed the process up? > > 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 > > -- Atenciosamente Alexandre Andrade Hipercenter.com Classificados Gratuitos e Inteligentes