Before starting to add multible records set your indexes inactive;

ALTER INDEX name INACTIVE;

then when finished set your indexes active

ALTER INDEX name ACTIVE;

----- Original Message -----

From: "Gerhardus Geldenhuis" <linuxmail@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, June 18, 2001 5:41 PM
Subject: [ib-support] Speed of indexes


> Hi
> I am doing a very basic volume experiment and so far I have found the
> following. With IBO I can roughly insert 5000 records over a network
> (tcp/ip)a minute. The table the however does not contain any indexes
except
> the primary key. When adding only two indexes this time increase about
> five-fold. My table roughly contains about 3million records. A query
(select
> * where name < 10000) takes about 40 seconds to complete. When I add a
index
> however this comes down to about 5 secs.
> Is there anyway to speed-up inserts with a table that has indexes?
>
> Btw All of my data is generated like this(value=random(x)). My reasoning
is
> that it won't matter whether a char field contains numbers or letters.
>
> Is there other interesting performance tests I can run on such a large
> database. The database is just over 600megs in physical size.
>
> Groete
> Gerhardus
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>