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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
