Good tip.

Joe

>Nigel,
>
>One more tip:
>
>If RI or stored procedures are used in the large table, make sure that the related tables are already open in another workarea. This shortens the time needed to run the stored procs or RI code dramaticly, because:
>
> - Every time a record is insterted one or more related tables have to be opened and closed. If the table is already opened in another workarea, it shortens the time needed to open the table (because of loading buffers).
>
> - It reduces network trafic because if you don't have the tables already open, it has to load the buffers from the server for every table on every record which is replace or inserted.
>
>peformance gains between 100% and 300% are possible. (I never tested this on slow networks)
>
>Walter,