>
>A solution might be to make a offline-copy of the table and use this table to make reports etc.
* This is basically what the interim table will be doing if I go that way.
>
>If not possible try to convince yourself of the folowing:
>
>- The app does not apply File locking in any code. for e.G:
> DO not use: REPLACE field WITh valueexpression FOR somecondition
> But use:
> SCAN FOR somecondition
> REPLACE Field WITH ValueExpression
> ENDSCAN
>
>- The app doesn't use pessimistic buffering.
>- The app will prohibit deadlocks (By using a SET REPROCESS TO n SECONDS and handling errors)
>- The right indexes are used on the table: Not too much indexes, not too less.
>- You don't use a tag on deleted() (unless the table contains millions of deleted records) Indexes themself take up time to in optimization and in modifying data. Asure yourself that the indexes on the table are needed.
>
>Some other considerations, thoughts and comments:
>- Is the network trafic too high ?
>- Which network (Novell, NT ?, others ?)
>- 10 MB, 100MB network, network achitecture ?
>
>Good luck,
>
>Walter,
All these points have been covered over the last couple of months (it was one hell of a mess before then).