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

Reply via email to