Subject Insert speed very slow in large DB
Author dbambo2000
I have a table with 6 columns (3 of which are 18 digit numeric
fields). There are 57 million records in the table (an 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!

I'm running firebird 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.

Anyone have any ideas to help me SPEED THIS UP???

Thanks!