When you delete such big amount of data from a table, the next time
you access it (ie: select * from table) will trigger the garbage
collection, and for 5 mi records, GC can take some big time, letting
you think that FB is not answering, but actually, it is just doing its
cleaning work.

In this situation, if you can, I suggest you to run a gbak -b -g to
backup the database and after that do a restore. This will remove any
garbage, but of course, nobody would be able to use the DB while you
are doing this process.

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br

c> Hello guys,
c> please help me out, i have a firebird 1.5 database and 1.2 ODBC firebird.

c> My problem is, i have a table that comprise 5,340,000 records, and
c> it taking time to "Insert" records so idecided to delete all the
c> records by sending "DELETE FROM MYTABLE" command ,then after that
c> i'cant open the table that i deleted the rows, any suggestion or
c> help i can fix this problem, The table i'm taking about has stored
c> procedure dependencies, and how to speed up inserting to my table with 5million of records.

c> thanks in advance



c> ------------------------------------

c> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

c> Visit http://www.firebirdsql.org and click the Resources item
c> on the main (top) menu. Try Knowledgebase and FAQ links !

c> Also search the knowledgebases at http://www.ibphoenix.com

c> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
c> Yahoo! Groups Links