| Subject | Re: [firebird-support] gfix -sweep Versus gbak -g |
|---|---|
| Author | |
| Post date | 2013-11-04T14:05:29Z |
Hello Fabiano,
Did you find a solution to the reports running slower with each successive run? I am having a similar problem that started when I upgraded from Firebird version 2.1 to version 2.5. My SQL queries run consistently fast with Firebird 2.1, but when using Firebird 2.5, the query is as fast as 2.1 only for the first run. Then each successive run of the query with Firebird 2.5 takes longer than the previous run. Disconnecting and reconnecting to the database will cause the query to run in the expected time for the first run again, but then each run continues to slow down again until disconnection/reconnecting. Please see my post to the firebird-support mail list on October 24, 2013 titled "Query Performance Problem after Upgrading from Firebird 2.1 to 2.5". No one has responded to my issue. The only update that I have is I have also tried the Firebird Jaybird 2.2.3 JDBC driver and have the same problem with Firebird 2.5 but not 2.1.
Thank you,
Paul
---------------------------------------------------------------------------------
Confidentiality Notice: This message is the property of the United States Bankruptcy Court for the Western District of Kentucky. It may be legally privileged and/or confidential and is intended solely for the use of the addressee. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized disclosure, dissemination, distribution, copying or taking any action in reliance on the information contained herein is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this message.
Did you find a solution to the reports running slower with each successive run? I am having a similar problem that started when I upgraded from Firebird version 2.1 to version 2.5. My SQL queries run consistently fast with Firebird 2.1, but when using Firebird 2.5, the query is as fast as 2.1 only for the first run. Then each successive run of the query with Firebird 2.5 takes longer than the previous run. Disconnecting and reconnecting to the database will cause the query to run in the expected time for the first run again, but then each run continues to slow down again until disconnection/reconnecting. Please see my post to the firebird-support mail list on October 24, 2013 titled "Query Performance Problem after Upgrading from Firebird 2.1 to 2.5". No one has responded to my issue. The only update that I have is I have also tried the Firebird Jaybird 2.2.3 JDBC driver and have the same problem with Firebird 2.5 but not 2.1.
Thank you,
Paul
---------------------------------------------------------------------------------
Confidentiality Notice: This message is the property of the United States Bankruptcy Court for the Western District of Kentucky. It may be legally privileged and/or confidential and is intended solely for the use of the addressee. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized disclosure, dissemination, distribution, copying or taking any action in reliance on the information contained herein is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this message.