> I have a form that displays data from the database. It has an edit
> button that enables the field inputs on the form to be editable and
> also starts a transaction. If you click edit it displays two more
> buttons a Cancel and a Save button.
>
> Here is my problem if you use this form over and over again the Commit
> time seems to take longer and longer. Closing the form and opening it
> back up does not speed it up at all. You have to close the application
> and reopen and then it builds up again to eventually take longer and
> longer each time.
>
> Is this a known issue? Has anyone seen this before?
>
> Any help would be greatly appreciated!

You are likely not actually ending the physical transaction.

Are you calling CommitRetaining when you click "Save" or are you calling
"Commit"?

Jason Wharton