Subject | Insert speed very slow in large DB |
---|---|
Author | dbambo2000 |
Post date | 2005-09-19T21:24Z |
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!
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!