> Hi,
>
>
>
> We are facing some issues with the release of database pages after
> delete all records in the table.
>
>
>
> Since there are no temporary tables in Firebird, like ORACLE, we are
> inserting updating data in the normal tables and then deleting when the
> process is completed. However, there seems to be some issue with the
> Firebird Server 1.5.3 as it does not release the pages after all the
> records are deleted. When we check the RDB$PAGES table it still shows
> pages against these tables with 0 records. As a result, the subsequent
> operations on these tables take a performance hit as if data still
> persists.
>
>
>
> Is there anyway in which we can release / de-allocate these pages to the
> operating system. If this is a genuine issue with this version, could
> you please suggest any other technique to circumvent this problem?
>
>
>
> Thanks and Regards,
>
> Hemant.

there is no issue. Your next mass insert will use up these pages again.
Once you finish doing mass updates and deletes you can backup and restore.
Before that point it's not worth thinking. Search the newsgroup if you want
more info. But it's not a problem and causes no loss of performance. Let FB
manage it's disk space the way it's been designed to.
Alan