Geek Answers Handbook

My Delphi 7 with Firebird 1.5.6 App freezes after some time of inactivity in Windows 7

I developed a Delphi 7 application that uses the Firebird 1.5.6 database in a server environment client.

The application runs on Windows 7 32-bit on a laptop, and the database is running on a 32-bit Windows XP machine, which is used as a server. The problem is that the application freezes when it remains inactive for some time. This problem never occurred in Windows XP, only when we installed it in Windows 7.

Everything worked fine for 5 years, but now in Windows 7 the application is completely unstable.

Sometimes the wake-up time is 10-30 seconds with success, but sometimes never with the messages "application does not respond" or "application failure".

I have no idea where to look or what to try to find a solution. I tried to make a timer with a resolution of 10 seconds, so that it worked constantly but without success.

BTW I work in administrator mode with active XP compatibility mode. I have not tried virtual XP mode yet, but I think this will not solve the problem.

+5
source share
3 answers

Could it be that the database file extension is .gdb and Windows is backing up the XP file as described here. http://www.firebirdfaq.org/faq353/ ?

0
source

: ( Firebird ) 32- Windows 7 (Delphi 7).

(60 ). firebird.conf, DUMMY_PACKET_INTERVAL.

, , , .
, , .
firebird.log .

. . .

0

, , . , . , / . , , ( ).

, firebird . .

  • , firebird .

  • firebird , 20000 , , .

The solution is to not use the autocommit transaction. And if your daily transaction score is high, then set the number of firebird to a larger value and do the garbage collection yourself at a more appropriate time.

0
source

More articles:


All Articles