Subject Re: [firebird-support] Transactions Locking and thus freezing clients
Author Helen Borrie
At 02:24 PM 23/03/2009, you wrote:
>I have developed a POS Application and about 10 computers are using the database at the same time. nowadays, the client computers are freezing after every 1-2 hours. when i debug the code...its freezing while adding the records to a particular Database File. sometimes it freezes when opening the Database...other times it freezes while adding record to the table.
>Can somebody help plz.

You're talking here about at least two potential areas of difficulty in your application.

1) the handling of transactions, including use of inappropriate transaction settings
2) the handling of exceptions

>sometimes it freezes when opening the Database...

You would have to give a lot more information about what you have set up there, like which model of Firebird (Classic/Superserver), which version of Firebird...and describing the language environment, including its data access interface, would probably help to shed some light.