| Subject | Problem after deleting huge records of rows in a table |
|---|---|
| Author | crizaldogordo |
| Post date | 2011-05-21T07:51:23Z |
Hello guys,
please help me out, i have a firebird 1.5 database and 1.2 ODBC firebird.
My problem is, i have a table that comprise 5,340,000 records, and it taking time to "Insert" records so idecided to delete all the records by sending "DELETE FROM MYTABLE" command ,then after that i'cant open the table that i deleted the rows, any suggestion or help i can fix this problem, The table i'm taking about has stored procedure dependencies, and how to speed up inserting to my table with 5million of records.
thanks in advance
please help me out, i have a firebird 1.5 database and 1.2 ODBC firebird.
My problem is, i have a table that comprise 5,340,000 records, and it taking time to "Insert" records so idecided to delete all the records by sending "DELETE FROM MYTABLE" command ,then after that i'cant open the table that i deleted the rows, any suggestion or help i can fix this problem, The table i'm taking about has stored procedure dependencies, and how to speed up inserting to my table with 5million of records.
thanks in advance