Re: Interested in Solving Some Problems

From: Roger Wernersson <roger.wernersson_at_adra.se>
Date: 1997/08/20
Message-ID: <33FAB5D0.66FF@adra.se>#1/1

V. Chandrasekhar wrote:
> (1) The database is fairly full. (I realize that I have not
> defined what 'fairly' is. There appears to be definitely room
> for adding the rows.) This seems to slow the
> application - i.e., the inserts - down. I am surprised by this.
> As long as all that is happening is adding new rows, will
> the size of the database have an effect, as long as there
> is room ?

IMHO row inserts takes time as the indexes must be updated, and this is true for deletes also. If you drop a table, you drop the indexes too without any update which makes it faster. An insert takes more time on a large table with many indexes.

/Roger Received on Wed Aug 20 1997 - 00:00:00 CDT