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?

Regards,


Ann