I have a similar problem. One of my forms is master-detail, in
detail i have procedures for insert, update and delete (not
requestlive query), couple of other queries for lookup combo boxes
and totals and with each scroll up and down in master it is slower
and slower. On other forms whaich are similar don't have that
problem.

Rade
--- In IBObjects@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

>
> --- In IBObjects@yahoogroups.com, "Bill Gage" wrote:
> >
> > I have an app that is running several stored procedures on a
> > database. It seems that as the process of running all the
> > procedures progresses the application starts to slow down. I

start

> > a transaction before every stored procedure and commit after

each

> > one.
>
> I guess a common mistake possibly resulting in this behaviour is

to

> use CommitRetaining rather than Commit.
>
> Set