> Thanks, it makes a huge speed difference.
> But could someone tell me what BeginBusy does, can't seem to find any
> info in the help file of IBO, only its declaration.

At the session level I keep tract of the SQL-Hourglass status and turn it on
and off. By calling BeginBusy you indicate that the SQL-Hourglass should be
turned on. All subsequent calls to BeginBusy merely increment an integer
flag and then when EndBusy is called it decrements it until it goes down to
zero and then the SQL-Hourglass is turned off.

If you have code with a bunch of granular data access operations and you
don't bracket it with a begin/end busy block then you turn the SQL-Hourglass
on and off for each time one of them is made. This can be very expensive, as
you found out.

IBX's solution to this problem was to simply remove any SQL hourglass
functionality.

Jason Wharton