Check the page size of the restored vs previous db
Alan

On 24/07/2013 8:19 PM, "SysAdm" <sysadm@...> wrote:

> Hello,
> I have this strange problem on gbak. Usually every night I was doing a
> full backup of a database and a subsequent restore order to remove the
> garbage and optimize the database. But when I set out the work on a new
> server environment in FreeBSD 8.4 I faced enormous problems of slowing
> down and malfunctions on the restored database. These problems do not
> occur on the original one, but only on the restored file. The slowness
> of the restored version is really excessive, in the sense that a query
> that on the original version requires no more than a second, in the
> restored version employs even one hour. I tried to rebuild all indexes
> (deactivating and reactivating), to remove them and put them back, to
> recalculate the statistics, upgrade the operating system from version
> 8.1 to 8.4 to recompile and reinstall all ports, including firebird
> itself, but the result is always the same. This does not occur on
> another machine that runs FreeBSD 8.2 and the same version of firebird:
> FB-V2.5.2.26540 Firebird 2.5. On this machine the operation has fully
> happened with the result of a further acceleration of the database. What
> can I do?
> Lorenzo Iania
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>


[Non-text portions of this message have been removed]