Too much time to insert records into tables

From: Rajeev Sethi <rajsethi_at_ix.netcom.com>
Date: 1995/09/18
Message-ID: <43krsc$8v5_at_ixnews4.ix.netcom.com>#1/1


Hi,

    Currently there are 50-70 users trying insert records into 2 tables (Master-Detail). The system slowsdown drastically when users are inserting records in these tables. Sometimes it takes about 4 min. to commit its transaction. (which is not acceptable).

There is no explicit table locking.

Is there anyway to speed the data entry ?

Thanks for the replies.

Rajeev Sethi
rajsethi_at_ix.netcom.com      Received on Mon Sep 18 1995 - 00:00:00 CEST

Original text of this message