Hi Sir Carlos,
Thanks for your time in answering my question
i'll try your suggestion and i'll let you know the result.
thanks

--- In firebird-support@yahoogroups.com, "Carlos H. Cantu" <listas@...> wrote:
>
> 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
>