--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> dbambo2000 wrote:
> > I have a table with 6 columns ... 57 million records ... 5 gigabyte
> > file). Four of the columns have indexes (including all 3 numeric
> > fields). Inserting just two new records via
> >
> > "Insert into tableX (col1, col2, col3 ...)VALUES (val1, val2,
> > val3...)"
> >
> > takes between 5 and 10 minutes!
> >
> > ...super server Version 1.5 on a Windows XP Pro P4
> > machine with 756MB Ram. My application uses Coldfusion and ODBC to
> > connect to the database.
> >
>
> Do you have any triggers on the table?
>

No. There are no triggers. There is a generator to increment one of
the index values.

> Regards,
>
>
> Ann