Subject Re: [firebird-support] Insert speed very slow in large DB
Author Ann W. Harrison
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?