At 04:41 PM 18-06-01 +0200, you wrote:

>Is there anyway to speed-up inserts with a table that has indexes?

Yes: deactivate them.

>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.

The casting involved might introduce overhead in huge batches. Ann?

-- HB

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________