We have a pretty large database (1,8Gb and growing). We collect data from different parties in this database, in this process a lot of records are inserted (and sometimes deleted). Once a month we create a number of reports from this database.
Here is the problem. When our app (written in Delphi 5) is closed, it disappears from the windows task list, but stays present in the process list and also IBServer is using cpu-time. This can take more than a few hours and then our process is disappeared and IBServer is idle. What may IBServer be doing?? We have turned off automatic sweeping and we do a backup/restore on a regular basis.
Here is the problem. When our app (written in Delphi 5) is closed, it disappears from the windows task list, but stays present in the process list and also IBServer is using cpu-time. This can take more than a few hours and then our process is disappeared and IBServer is idle. What may IBServer be doing?? We have turned off automatic sweeping and we do a backup/restore on a regular basis.
