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