> Besides - Sometimes our users makes a report (or something similar)
> and shows this to the screen. Then every once in a while, the user
> just leaves the computer - And goes home (I don't know, but they are
> don't user the computer for more than 4 hours i.e.).
>
> They will have an open transaction and a long running as well.
> What do you do to solve this ?

Every time we generate a report we first gather the necessary data in
a memory dataset and then use it to generate the report, so the
transaction is only open while fetching data, no matter what kind of
report.

Best regards,
Eduardo Mauro
Acabit Tecnologia Ltda.